<HTML>
<BODY BGCOLOR="white">
<PRE>
<FONT color="green">001</FONT>    package org.hackystat.sensorbase.db.derby;<a name="line.1"></a>
<FONT color="green">002</FONT>    <a name="line.2"></a>
<FONT color="green">003</FONT>    import static org.hackystat.sensorbase.server.ServerProperties.DB_DIR_KEY;<a name="line.3"></a>
<FONT color="green">004</FONT>    <a name="line.4"></a>
<FONT color="green">005</FONT>    import java.math.BigInteger;<a name="line.5"></a>
<FONT color="green">006</FONT>    import java.sql.CallableStatement;<a name="line.6"></a>
<FONT color="green">007</FONT>    import java.sql.Connection;<a name="line.7"></a>
<FONT color="green">008</FONT>    import java.sql.DriverManager;<a name="line.8"></a>
<FONT color="green">009</FONT>    import java.sql.PreparedStatement;<a name="line.9"></a>
<FONT color="green">010</FONT>    import java.sql.ResultSet;<a name="line.10"></a>
<FONT color="green">011</FONT>    import java.sql.SQLException;<a name="line.11"></a>
<FONT color="green">012</FONT>    import java.sql.Statement;<a name="line.12"></a>
<FONT color="green">013</FONT>    import java.sql.Timestamp;<a name="line.13"></a>
<FONT color="green">014</FONT>    import java.util.ArrayList;<a name="line.14"></a>
<FONT color="green">015</FONT>    import java.util.Date;<a name="line.15"></a>
<FONT color="green">016</FONT>    import java.util.HashMap;<a name="line.16"></a>
<FONT color="green">017</FONT>    import java.util.HashSet;<a name="line.17"></a>
<FONT color="green">018</FONT>    import java.util.Iterator;<a name="line.18"></a>
<FONT color="green">019</FONT>    import java.util.List;<a name="line.19"></a>
<FONT color="green">020</FONT>    import java.util.Map;<a name="line.20"></a>
<FONT color="green">021</FONT>    import java.util.Set;<a name="line.21"></a>
<FONT color="green">022</FONT>    <a name="line.22"></a>
<FONT color="green">023</FONT>    import javax.xml.datatype.XMLGregorianCalendar;<a name="line.23"></a>
<FONT color="green">024</FONT>    <a name="line.24"></a>
<FONT color="green">025</FONT>    import org.hackystat.sensorbase.db.DbImplementation;<a name="line.25"></a>
<FONT color="green">026</FONT>    import org.hackystat.utilities.stacktrace.StackTrace;<a name="line.26"></a>
<FONT color="green">027</FONT>    import org.hackystat.utilities.tstamp.Tstamp;<a name="line.27"></a>
<FONT color="green">028</FONT>    import org.hackystat.sensorbase.resource.projects.jaxb.Project;<a name="line.28"></a>
<FONT color="green">029</FONT>    import org.hackystat.sensorbase.resource.projects.jaxb.ProjectSummary;<a name="line.29"></a>
<FONT color="green">030</FONT>    import org.hackystat.sensorbase.resource.projects.jaxb.SensorDataSummaries;<a name="line.30"></a>
<FONT color="green">031</FONT>    import org.hackystat.sensorbase.resource.projects.jaxb.SensorDataSummary;<a name="line.31"></a>
<FONT color="green">032</FONT>    import org.hackystat.sensorbase.resource.sensordata.jaxb.SensorData;<a name="line.32"></a>
<FONT color="green">033</FONT>    import org.hackystat.sensorbase.resource.sensordatatypes.jaxb.SensorDataType;<a name="line.33"></a>
<FONT color="green">034</FONT>    import org.hackystat.sensorbase.resource.users.jaxb.User;<a name="line.34"></a>
<FONT color="green">035</FONT>    import org.hackystat.sensorbase.server.Server;<a name="line.35"></a>
<FONT color="green">036</FONT>    <a name="line.36"></a>
<FONT color="green">037</FONT>    <a name="line.37"></a>
<FONT color="green">038</FONT>    /**<a name="line.38"></a>
<FONT color="green">039</FONT>     * Provides a implementation of DbImplementation using Derby in embedded mode.<a name="line.39"></a>
<FONT color="green">040</FONT>     * <a name="line.40"></a>
<FONT color="green">041</FONT>     * Note: If you are using this implementation as a guide for implementing an alternative database,<a name="line.41"></a>
<FONT color="green">042</FONT>     * you should be aware that this implementation does not do connection pooling.  It turns out<a name="line.42"></a>
<FONT color="green">043</FONT>     * that embedded Derby does not require connection pooling, so it is not present in this code.<a name="line.43"></a>
<FONT color="green">044</FONT>     * You will probably want it for your version, of course. <a name="line.44"></a>
<FONT color="green">045</FONT>     * <a name="line.45"></a>
<FONT color="green">046</FONT>     * @author Philip Johnson<a name="line.46"></a>
<FONT color="green">047</FONT>     */<a name="line.47"></a>
<FONT color="green">048</FONT>    public class DerbyImplementation extends DbImplementation {<a name="line.48"></a>
<FONT color="green">049</FONT>      <a name="line.49"></a>
<FONT color="green">050</FONT>      /** The JDBC driver. */<a name="line.50"></a>
<FONT color="green">051</FONT>      private static final String driver = "org.apache.derby.jdbc.EmbeddedDriver";<a name="line.51"></a>
<FONT color="green">052</FONT>      <a name="line.52"></a>
<FONT color="green">053</FONT>      /** The Database name. */<a name="line.53"></a>
<FONT color="green">054</FONT>      private static final String dbName = "sensorbase";<a name="line.54"></a>
<FONT color="green">055</FONT>      <a name="line.55"></a>
<FONT color="green">056</FONT>      /**  The Derby connection URL. */ <a name="line.56"></a>
<FONT color="green">057</FONT>      private static final String connectionURL = "jdbc:derby:" + dbName + ";create=true";<a name="line.57"></a>
<FONT color="green">058</FONT>      <a name="line.58"></a>
<FONT color="green">059</FONT>      /** Indicates whether this database was initialized or was pre-existing. */<a name="line.59"></a>
<FONT color="green">060</FONT>      private boolean isFreshlyCreated;<a name="line.60"></a>
<FONT color="green">061</FONT>      <a name="line.61"></a>
<FONT color="green">062</FONT>      /** The SQL state indicating that INSERT tried to add data to a table with a preexisting key. */<a name="line.62"></a>
<FONT color="green">063</FONT>      private static final String DUPLICATE_KEY = "23505";<a name="line.63"></a>
<FONT color="green">064</FONT>      <a name="line.64"></a>
<FONT color="green">065</FONT>      /** The key for putting/retrieving the directory where Derby will create its databases. */<a name="line.65"></a>
<FONT color="green">066</FONT>      private static final String derbySystemKey = "derby.system.home";<a name="line.66"></a>
<FONT color="green">067</FONT>      <a name="line.67"></a>
<FONT color="green">068</FONT>      /** The logger message for connection closing errors. */<a name="line.68"></a>
<FONT color="green">069</FONT>      private static final String errorClosingMsg = "Derby: Error while closing. \n";<a name="line.69"></a>
<FONT color="green">070</FONT>      <a name="line.70"></a>
<FONT color="green">071</FONT>      /** The logger message when executing a query. */<a name="line.71"></a>
<FONT color="green">072</FONT>      private static final String executeQueryMsg = "Derby: Executing query ";<a name="line.72"></a>
<FONT color="green">073</FONT>      <a name="line.73"></a>
<FONT color="green">074</FONT>      /** Required by PMD since this string occurs multiple times in this file. */<a name="line.74"></a>
<FONT color="green">075</FONT>      private static final String ownerEquals = " owner = '";<a name="line.75"></a>
<FONT color="green">076</FONT>    <a name="line.76"></a>
<FONT color="green">077</FONT>      /** Required by PMD since this string occurs multiple times in this file. */<a name="line.77"></a>
<FONT color="green">078</FONT>      private static final String sdtEquals = " sdt = '";<a name="line.78"></a>
<FONT color="green">079</FONT>      private static final String toolEquals = " tool = '";<a name="line.79"></a>
<FONT color="green">080</FONT>      <a name="line.80"></a>
<FONT color="green">081</FONT>      /** Required by PMD as above. */<a name="line.81"></a>
<FONT color="green">082</FONT>      private static final String quoteAndClause = "' AND ";<a name="line.82"></a>
<FONT color="green">083</FONT>      private static final String andClause = " AND ";<a name="line.83"></a>
<FONT color="green">084</FONT>      private static final String selectPrefix = "SELECT XmlSensorDataRef FROM SensorData WHERE "; <a name="line.84"></a>
<FONT color="green">085</FONT>      private static final String selectSnapshot = <a name="line.85"></a>
<FONT color="green">086</FONT>        "SELECT XmlSensorDataRef, Runtime, Tool FROM SensorData WHERE "; <a name="line.86"></a>
<FONT color="green">087</FONT>      private static final String orderByTstamp = " ORDER BY tstamp";<a name="line.87"></a>
<FONT color="green">088</FONT>      private static final String orderByRuntime = " ORDER BY runtime DESC";<a name="line.88"></a>
<FONT color="green">089</FONT>      private static final String derbyError = "Derby: Error ";<a name="line.89"></a>
<FONT color="green">090</FONT>      private static final String indexSuffix = "Index&gt;";<a name="line.90"></a>
<FONT color="green">091</FONT>      private static final String xml = "Xml";<a name="line.91"></a>
<FONT color="green">092</FONT>    <a name="line.92"></a>
<FONT color="green">093</FONT>      /**<a name="line.93"></a>
<FONT color="green">094</FONT>       * Instantiates the Derby implementation.  Throws a Runtime exception if the Derby<a name="line.94"></a>
<FONT color="green">095</FONT>       * jar file cannot be found on the classpath.<a name="line.95"></a>
<FONT color="green">096</FONT>       * @param server The SensorBase server instance. <a name="line.96"></a>
<FONT color="green">097</FONT>       */<a name="line.97"></a>
<FONT color="green">098</FONT>      public DerbyImplementation(Server server) {<a name="line.98"></a>
<FONT color="green">099</FONT>        super(server);<a name="line.99"></a>
<FONT color="green">100</FONT>        // Set the directory where the DB will be created and/or accessed.<a name="line.100"></a>
<FONT color="green">101</FONT>        // This must happen before loading the driver. <a name="line.101"></a>
<FONT color="green">102</FONT>        String dbDir = server.getServerProperties().get(DB_DIR_KEY);<a name="line.102"></a>
<FONT color="green">103</FONT>        System.getProperties().put(derbySystemKey, dbDir);<a name="line.103"></a>
<FONT color="green">104</FONT>        // Try to load the derby driver. <a name="line.104"></a>
<FONT color="green">105</FONT>        try {<a name="line.105"></a>
<FONT color="green">106</FONT>          Class.forName(driver); <a name="line.106"></a>
<FONT color="green">107</FONT>        } <a name="line.107"></a>
<FONT color="green">108</FONT>        catch (java.lang.ClassNotFoundException e) {<a name="line.108"></a>
<FONT color="green">109</FONT>          String msg = "Derby: Exception during DbManager initialization: Derby not on CLASSPATH.";<a name="line.109"></a>
<FONT color="green">110</FONT>          this.logger.warning(msg + "\n" + StackTrace.toString(e));<a name="line.110"></a>
<FONT color="green">111</FONT>          throw new RuntimeException(msg, e);<a name="line.111"></a>
<FONT color="green">112</FONT>        }<a name="line.112"></a>
<FONT color="green">113</FONT>      }<a name="line.113"></a>
<FONT color="green">114</FONT>      <a name="line.114"></a>
<FONT color="green">115</FONT>    <a name="line.115"></a>
<FONT color="green">116</FONT>      /** {@inheritDoc} */<a name="line.116"></a>
<FONT color="green">117</FONT>      @Override<a name="line.117"></a>
<FONT color="green">118</FONT>      public void initialize() {<a name="line.118"></a>
<FONT color="green">119</FONT>        try {<a name="line.119"></a>
<FONT color="green">120</FONT>          // Create a shutdown hook that shuts down derby.<a name="line.120"></a>
<FONT color="green">121</FONT>          Runtime.getRuntime().addShutdownHook(new Thread() {<a name="line.121"></a>
<FONT color="green">122</FONT>            /** Run the shutdown hook for shutting down Derby. */<a name="line.122"></a>
<FONT color="green">123</FONT>            @Override <a name="line.123"></a>
<FONT color="green">124</FONT>            public void run() {<a name="line.124"></a>
<FONT color="green">125</FONT>              Connection conn = null;<a name="line.125"></a>
<FONT color="green">126</FONT>              try {<a name="line.126"></a>
<FONT color="green">127</FONT>                conn = DriverManager.getConnection("jdbc:derby:;shutdown=true");<a name="line.127"></a>
<FONT color="green">128</FONT>              }<a name="line.128"></a>
<FONT color="green">129</FONT>              catch (Exception e) {<a name="line.129"></a>
<FONT color="green">130</FONT>                System.out.println("Derby shutdown hook results: " + e.getMessage());<a name="line.130"></a>
<FONT color="green">131</FONT>              }<a name="line.131"></a>
<FONT color="green">132</FONT>              finally {<a name="line.132"></a>
<FONT color="green">133</FONT>                try {<a name="line.133"></a>
<FONT color="green">134</FONT>                  conn.close();<a name="line.134"></a>
<FONT color="green">135</FONT>                }<a name="line.135"></a>
<FONT color="green">136</FONT>                catch (Exception e) { //NOPMD<a name="line.136"></a>
<FONT color="green">137</FONT>                  // we tried.<a name="line.137"></a>
<FONT color="green">138</FONT>                }<a name="line.138"></a>
<FONT color="green">139</FONT>              }<a name="line.139"></a>
<FONT color="green">140</FONT>            }<a name="line.140"></a>
<FONT color="green">141</FONT>          });<a name="line.141"></a>
<FONT color="green">142</FONT>          // Initialize the database table structure if necessary.<a name="line.142"></a>
<FONT color="green">143</FONT>          this.isFreshlyCreated = !isPreExisting();<a name="line.143"></a>
<FONT color="green">144</FONT>          String dbStatusMsg = (this.isFreshlyCreated) ? <a name="line.144"></a>
<FONT color="green">145</FONT>              "Derby: uninitialized." : "Derby: previously initialized.";<a name="line.145"></a>
<FONT color="green">146</FONT>          this.logger.info(dbStatusMsg);<a name="line.146"></a>
<FONT color="green">147</FONT>          if (this.isFreshlyCreated) {<a name="line.147"></a>
<FONT color="green">148</FONT>            this.logger.info("Derby: creating DB in: " + System.getProperty(derbySystemKey));<a name="line.148"></a>
<FONT color="green">149</FONT>            createTables();<a name="line.149"></a>
<FONT color="green">150</FONT>          }<a name="line.150"></a>
<FONT color="green">151</FONT>          <a name="line.151"></a>
<FONT color="green">152</FONT>          if (server.getServerProperties().compressOnStartup()) {<a name="line.152"></a>
<FONT color="green">153</FONT>            this.logger.info("Derby: compressing database...");<a name="line.153"></a>
<FONT color="green">154</FONT>            compressTables();<a name="line.154"></a>
<FONT color="green">155</FONT>          }<a name="line.155"></a>
<FONT color="green">156</FONT>          if (server.getServerProperties().reindexOnStartup()) {<a name="line.156"></a>
<FONT color="green">157</FONT>            this.logger.info("Derby: reindexing database...");<a name="line.157"></a>
<FONT color="green">158</FONT>            this.logger.info("Derby: reindexing database " + ((indexTables()) ? "OK" : "not OK"));<a name="line.158"></a>
<FONT color="green">159</FONT>          }<a name="line.159"></a>
<FONT color="green">160</FONT>        }<a name="line.160"></a>
<FONT color="green">161</FONT>        catch (Exception e) {<a name="line.161"></a>
<FONT color="green">162</FONT>          String msg = "Derby: Exception during DerbyImplementation initialization:";<a name="line.162"></a>
<FONT color="green">163</FONT>          this.logger.warning(msg + "\n" + StackTrace.toString(e));<a name="line.163"></a>
<FONT color="green">164</FONT>          throw new RuntimeException(msg, e);<a name="line.164"></a>
<FONT color="green">165</FONT>        }<a name="line.165"></a>
<FONT color="green">166</FONT>    <a name="line.166"></a>
<FONT color="green">167</FONT>      }<a name="line.167"></a>
<FONT color="green">168</FONT>      <a name="line.168"></a>
<FONT color="green">169</FONT>      /**<a name="line.169"></a>
<FONT color="green">170</FONT>       * Determine if the database has already been initialized with correct table definitions. <a name="line.170"></a>
<FONT color="green">171</FONT>       * Table schemas are checked by seeing if a dummy insert on the table will work OK.<a name="line.171"></a>
<FONT color="green">172</FONT>       * @return True if the database exists and tables are set up correctly.<a name="line.172"></a>
<FONT color="green">173</FONT>       * @throws SQLException If problems occur accessing the database or the tables are set right. <a name="line.173"></a>
<FONT color="green">174</FONT>       */<a name="line.174"></a>
<FONT color="green">175</FONT>      private boolean isPreExisting() throws SQLException {<a name="line.175"></a>
<FONT color="green">176</FONT>        Connection conn = null;<a name="line.176"></a>
<FONT color="green">177</FONT>        Statement s = null;<a name="line.177"></a>
<FONT color="green">178</FONT>        try {<a name="line.178"></a>
<FONT color="green">179</FONT>          conn = DriverManager.getConnection(connectionURL);<a name="line.179"></a>
<FONT color="green">180</FONT>          s = conn.createStatement();<a name="line.180"></a>
<FONT color="green">181</FONT>          s.execute(testSensorDataTableStatement);<a name="line.181"></a>
<FONT color="green">182</FONT>          s.execute(testSensorDataTypeTableStatement);<a name="line.182"></a>
<FONT color="green">183</FONT>          s.execute(testUserTableStatement);<a name="line.183"></a>
<FONT color="green">184</FONT>          s.execute(testProjectTableStatement);<a name="line.184"></a>
<FONT color="green">185</FONT>        }  <a name="line.185"></a>
<FONT color="green">186</FONT>        catch (SQLException e) {<a name="line.186"></a>
<FONT color="green">187</FONT>          String theError = (e).getSQLState();<a name="line.187"></a>
<FONT color="green">188</FONT>          if ("42X05".equals(theError)) {<a name="line.188"></a>
<FONT color="green">189</FONT>            // Database doesn't exist.<a name="line.189"></a>
<FONT color="green">190</FONT>            return false;<a name="line.190"></a>
<FONT color="green">191</FONT>          }  <a name="line.191"></a>
<FONT color="green">192</FONT>          else if ("42X14".equals(theError) || "42821".equals(theError))  {<a name="line.192"></a>
<FONT color="green">193</FONT>            // Incorrect table definition. <a name="line.193"></a>
<FONT color="green">194</FONT>            throw e;   <a name="line.194"></a>
<FONT color="green">195</FONT>          } <a name="line.195"></a>
<FONT color="green">196</FONT>          else { <a name="line.196"></a>
<FONT color="green">197</FONT>            // Unknown SQLException<a name="line.197"></a>
<FONT color="green">198</FONT>            throw e; <a name="line.198"></a>
<FONT color="green">199</FONT>          }<a name="line.199"></a>
<FONT color="green">200</FONT>        }<a name="line.200"></a>
<FONT color="green">201</FONT>        finally {<a name="line.201"></a>
<FONT color="green">202</FONT>          if (s != null) {<a name="line.202"></a>
<FONT color="green">203</FONT>            s.close();<a name="line.203"></a>
<FONT color="green">204</FONT>          }<a name="line.204"></a>
<FONT color="green">205</FONT>          if (conn != null) {<a name="line.205"></a>
<FONT color="green">206</FONT>            conn.close();<a name="line.206"></a>
<FONT color="green">207</FONT>          }<a name="line.207"></a>
<FONT color="green">208</FONT>        }<a name="line.208"></a>
<FONT color="green">209</FONT>        // If table exists will get -  WARNING 02000: No row was found <a name="line.209"></a>
<FONT color="green">210</FONT>        return true;<a name="line.210"></a>
<FONT color="green">211</FONT>      }<a name="line.211"></a>
<FONT color="green">212</FONT>      <a name="line.212"></a>
<FONT color="green">213</FONT>      /**<a name="line.213"></a>
<FONT color="green">214</FONT>       * Initialize the database by creating tables for each resource type.<a name="line.214"></a>
<FONT color="green">215</FONT>       * @throws SQLException If table creation fails.<a name="line.215"></a>
<FONT color="green">216</FONT>       */<a name="line.216"></a>
<FONT color="green">217</FONT>      private void createTables() throws SQLException {<a name="line.217"></a>
<FONT color="green">218</FONT>        Connection conn = null;<a name="line.218"></a>
<FONT color="green">219</FONT>        Statement s = null;<a name="line.219"></a>
<FONT color="green">220</FONT>        try {<a name="line.220"></a>
<FONT color="green">221</FONT>          conn = DriverManager.getConnection(connectionURL);<a name="line.221"></a>
<FONT color="green">222</FONT>          s = conn.createStatement();<a name="line.222"></a>
<FONT color="green">223</FONT>          s.execute(createSensorDataTableStatement);<a name="line.223"></a>
<FONT color="green">224</FONT>          s.execute(indexSensorDataTstampStatement);<a name="line.224"></a>
<FONT color="green">225</FONT>          s.execute(indexSensorDataRuntimeStatement);<a name="line.225"></a>
<FONT color="green">226</FONT>          s.execute(indexSensorDataToolStatement);<a name="line.226"></a>
<FONT color="green">227</FONT>          s.execute(createSensorDataTypeTableStatement);<a name="line.227"></a>
<FONT color="green">228</FONT>          s.execute(createUserTableStatement);<a name="line.228"></a>
<FONT color="green">229</FONT>          s.execute(createProjectTableStatement);<a name="line.229"></a>
<FONT color="green">230</FONT>          s.close();<a name="line.230"></a>
<FONT color="green">231</FONT>        }<a name="line.231"></a>
<FONT color="green">232</FONT>        finally {<a name="line.232"></a>
<FONT color="green">233</FONT>          s.close();<a name="line.233"></a>
<FONT color="green">234</FONT>          conn.close();<a name="line.234"></a>
<FONT color="green">235</FONT>        }<a name="line.235"></a>
<FONT color="green">236</FONT>      }<a name="line.236"></a>
<FONT color="green">237</FONT>      <a name="line.237"></a>
<FONT color="green">238</FONT>      // ********************   Start  Sensor Data specific stuff here *****************  //<a name="line.238"></a>
<FONT color="green">239</FONT>    <a name="line.239"></a>
<FONT color="green">240</FONT>      /** The SQL string for creating the SensorData table. */<a name="line.240"></a>
<FONT color="green">241</FONT>      private static final String createSensorDataTableStatement = <a name="line.241"></a>
<FONT color="green">242</FONT>        "create table SensorData " <a name="line.242"></a>
<FONT color="green">243</FONT>        + "("<a name="line.243"></a>
<FONT color="green">244</FONT>        + " Owner VARCHAR(64) NOT NULL, "<a name="line.244"></a>
<FONT color="green">245</FONT>        + " Tstamp TIMESTAMP NOT NULL, "<a name="line.245"></a>
<FONT color="green">246</FONT>        + " Sdt VARCHAR(64) NOT NULL, "<a name="line.246"></a>
<FONT color="green">247</FONT>        + " Runtime TIMESTAMP NOT NULL, "<a name="line.247"></a>
<FONT color="green">248</FONT>        + " Tool VARCHAR(64) NOT NULL, "<a name="line.248"></a>
<FONT color="green">249</FONT>        + " Resource VARCHAR(512) NOT NULL, "<a name="line.249"></a>
<FONT color="green">250</FONT>        + " XmlSensorData VARCHAR(32000) NOT NULL, "<a name="line.250"></a>
<FONT color="green">251</FONT>        + " XmlSensorDataRef VARCHAR(1000) NOT NULL, "<a name="line.251"></a>
<FONT color="green">252</FONT>        + " LastMod TIMESTAMP NOT NULL, " //NOPMD (Don't worry about repeat occurrences of this string)<a name="line.252"></a>
<FONT color="green">253</FONT>        + " PRIMARY KEY (Owner, Tstamp) "<a name="line.253"></a>
<FONT color="green">254</FONT>        + ")" ;<a name="line.254"></a>
<FONT color="green">255</FONT>      <a name="line.255"></a>
<FONT color="green">256</FONT>      /** An SQL string to test whether the SensorData table exists and has the correct schema. */<a name="line.256"></a>
<FONT color="green">257</FONT>      private static final String testSensorDataTableStatement = <a name="line.257"></a>
<FONT color="green">258</FONT>        " UPDATE SensorData SET "<a name="line.258"></a>
<FONT color="green">259</FONT>        + " Owner = 'TestUser', " <a name="line.259"></a>
<FONT color="green">260</FONT>        + " Tstamp = '" + new Timestamp(new Date().getTime()).toString() + "', " //NOPMD (dup string)<a name="line.260"></a>
<FONT color="green">261</FONT>        + " Sdt = 'testSdt',"<a name="line.261"></a>
<FONT color="green">262</FONT>        + " Runtime = '" + new Timestamp(new Date().getTime()).toString() + "', "<a name="line.262"></a>
<FONT color="green">263</FONT>        + " Tool = 'testTool', "<a name="line.263"></a>
<FONT color="green">264</FONT>        + " Resource = 'testResource', "<a name="line.264"></a>
<FONT color="green">265</FONT>        + " XmlSensorData = 'testXmlResource', "<a name="line.265"></a>
<FONT color="green">266</FONT>        + " XmlSensorDataRef = 'testXmlRef', "<a name="line.266"></a>
<FONT color="green">267</FONT>        + " LastMod = '" + new Timestamp(new Date().getTime()).toString() + "' " //NOPMD (dup string)<a name="line.267"></a>
<FONT color="green">268</FONT>        + " WHERE 1=3"; //NOPMD (duplicate string)<a name="line.268"></a>
<FONT color="green">269</FONT>      <a name="line.269"></a>
<FONT color="green">270</FONT>      private static final String indexSensorDataTstampStatement = <a name="line.270"></a>
<FONT color="green">271</FONT>        "CREATE INDEX TstampIndex ON SensorData(Tstamp asc)";<a name="line.271"></a>
<FONT color="green">272</FONT>      private static final String dropIndexSensorDataTstampStatement = <a name="line.272"></a>
<FONT color="green">273</FONT>        "DROP INDEX TstampIndex";<a name="line.273"></a>
<FONT color="green">274</FONT>    <a name="line.274"></a>
<FONT color="green">275</FONT>      private static final String indexSensorDataRuntimeStatement = <a name="line.275"></a>
<FONT color="green">276</FONT>        "CREATE INDEX RuntimeIndex ON SensorData(Runtime desc)";<a name="line.276"></a>
<FONT color="green">277</FONT>      private static final String dropIndexSensorDataRuntimeStatement = <a name="line.277"></a>
<FONT color="green">278</FONT>        "DROP INDEX RuntimeIndex";<a name="line.278"></a>
<FONT color="green">279</FONT>      <a name="line.279"></a>
<FONT color="green">280</FONT>      private static final String indexSensorDataToolStatement = <a name="line.280"></a>
<FONT color="green">281</FONT>        "CREATE INDEX ToolIndex ON SensorData(Tool asc)";<a name="line.281"></a>
<FONT color="green">282</FONT>      private static final String dropIndexSensorDataToolStatement = <a name="line.282"></a>
<FONT color="green">283</FONT>        "DROP INDEX ToolIndex";<a name="line.283"></a>
<FONT color="green">284</FONT>    <a name="line.284"></a>
<FONT color="green">285</FONT>    <a name="line.285"></a>
<FONT color="green">286</FONT>      /** {@inheritDoc} */<a name="line.286"></a>
<FONT color="green">287</FONT>     @Override<a name="line.287"></a>
<FONT color="green">288</FONT>      public boolean storeSensorData(SensorData data, String xmlSensorData, String xmlSensorDataRef) {<a name="line.288"></a>
<FONT color="green">289</FONT>        Connection conn = null;<a name="line.289"></a>
<FONT color="green">290</FONT>        PreparedStatement s = null;<a name="line.290"></a>
<FONT color="green">291</FONT>        try {<a name="line.291"></a>
<FONT color="green">292</FONT>          conn = DriverManager.getConnection(connectionURL);<a name="line.292"></a>
<FONT color="green">293</FONT>          s = conn.prepareStatement("INSERT INTO SensorData VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)");<a name="line.293"></a>
<FONT color="green">294</FONT>          // Order: Owner Tstamp Sdt Runtime Tool Resource XmlSensorData XmlSensorDataRef LastMod<a name="line.294"></a>
<FONT color="green">295</FONT>          s.setString(1, data.getOwner());<a name="line.295"></a>
<FONT color="green">296</FONT>          s.setTimestamp(2, Tstamp.makeTimestamp(data.getTimestamp()));<a name="line.296"></a>
<FONT color="green">297</FONT>          s.setString(3, data.getSensorDataType());<a name="line.297"></a>
<FONT color="green">298</FONT>          s.setTimestamp(4, Tstamp.makeTimestamp(data.getRuntime()));<a name="line.298"></a>
<FONT color="green">299</FONT>          s.setString(5, data.getTool());<a name="line.299"></a>
<FONT color="green">300</FONT>          s.setString(6, data.getResource());<a name="line.300"></a>
<FONT color="green">301</FONT>          s.setString(7, xmlSensorData);<a name="line.301"></a>
<FONT color="green">302</FONT>          s.setString(8, xmlSensorDataRef);<a name="line.302"></a>
<FONT color="green">303</FONT>          s.setTimestamp(9, new Timestamp(new Date().getTime()));<a name="line.303"></a>
<FONT color="green">304</FONT>          s.executeUpdate();<a name="line.304"></a>
<FONT color="green">305</FONT>          this.logger.fine("Derby: Inserted " + data.getOwner() + " " + data.getTimestamp());<a name="line.305"></a>
<FONT color="green">306</FONT>        }<a name="line.306"></a>
<FONT color="green">307</FONT>        catch (SQLException e) {<a name="line.307"></a>
<FONT color="green">308</FONT>          if (DUPLICATE_KEY.equals(e.getSQLState())) {<a name="line.308"></a>
<FONT color="green">309</FONT>            try {<a name="line.309"></a>
<FONT color="green">310</FONT>              // Do an update, not an insert.<a name="line.310"></a>
<FONT color="green">311</FONT>              s = conn.prepareStatement(<a name="line.311"></a>
<FONT color="green">312</FONT>                  "UPDATE SensorData SET "<a name="line.312"></a>
<FONT color="green">313</FONT>                  + " Sdt=?, Runtime=?, Tool=?, Resource=?, XmlSensorData=?, " <a name="line.313"></a>
<FONT color="green">314</FONT>                  + " XmlSensorDataRef=?, LastMod=?"<a name="line.314"></a>
<FONT color="green">315</FONT>                  + " WHERE Owner=? AND Tstamp=?");<a name="line.315"></a>
<FONT color="green">316</FONT>              s.setString(1, data.getSensorDataType());<a name="line.316"></a>
<FONT color="green">317</FONT>              s.setTimestamp(2, Tstamp.makeTimestamp(data.getRuntime()));<a name="line.317"></a>
<FONT color="green">318</FONT>              s.setString(3, data.getTool());<a name="line.318"></a>
<FONT color="green">319</FONT>              s.setString(4, data.getResource());<a name="line.319"></a>
<FONT color="green">320</FONT>              s.setString(5, xmlSensorData);<a name="line.320"></a>
<FONT color="green">321</FONT>              s.setString(6, xmlSensorDataRef);<a name="line.321"></a>
<FONT color="green">322</FONT>              s.setTimestamp(7, new Timestamp(new Date().getTime()));<a name="line.322"></a>
<FONT color="green">323</FONT>              s.setString(8, data.getOwner());<a name="line.323"></a>
<FONT color="green">324</FONT>              s.setTimestamp(9, Tstamp.makeTimestamp(data.getTimestamp()));<a name="line.324"></a>
<FONT color="green">325</FONT>              s.executeUpdate();<a name="line.325"></a>
<FONT color="green">326</FONT>              this.logger.fine("Derby: Updated " + data.getOwner() + " " + data.getTimestamp());<a name="line.326"></a>
<FONT color="green">327</FONT>            }<a name="line.327"></a>
<FONT color="green">328</FONT>            catch (SQLException f) {<a name="line.328"></a>
<FONT color="green">329</FONT>              this.logger.info(derbyError + StackTrace.toString(f));<a name="line.329"></a>
<FONT color="green">330</FONT>            }<a name="line.330"></a>
<FONT color="green">331</FONT>          }<a name="line.331"></a>
<FONT color="green">332</FONT>        }<a name="line.332"></a>
<FONT color="green">333</FONT>        finally {<a name="line.333"></a>
<FONT color="green">334</FONT>          try {<a name="line.334"></a>
<FONT color="green">335</FONT>            s.close();<a name="line.335"></a>
<FONT color="green">336</FONT>            conn.close();<a name="line.336"></a>
<FONT color="green">337</FONT>          }<a name="line.337"></a>
<FONT color="green">338</FONT>          catch (SQLException e) {<a name="line.338"></a>
<FONT color="green">339</FONT>            this.logger.warning(errorClosingMsg + StackTrace.toString(e));<a name="line.339"></a>
<FONT color="green">340</FONT>          }<a name="line.340"></a>
<FONT color="green">341</FONT>        }<a name="line.341"></a>
<FONT color="green">342</FONT>        return true;<a name="line.342"></a>
<FONT color="green">343</FONT>      }<a name="line.343"></a>
<FONT color="green">344</FONT>    <a name="line.344"></a>
<FONT color="green">345</FONT>    <a name="line.345"></a>
<FONT color="green">346</FONT>      /** {@inheritDoc} */<a name="line.346"></a>
<FONT color="green">347</FONT>      @Override<a name="line.347"></a>
<FONT color="green">348</FONT>      public boolean isFreshlyCreated() {<a name="line.348"></a>
<FONT color="green">349</FONT>        return this.isFreshlyCreated;<a name="line.349"></a>
<FONT color="green">350</FONT>      }<a name="line.350"></a>
<FONT color="green">351</FONT>      <a name="line.351"></a>
<FONT color="green">352</FONT>      <a name="line.352"></a>
<FONT color="green">353</FONT>      /** {@inheritDoc} */<a name="line.353"></a>
<FONT color="green">354</FONT>      @Override<a name="line.354"></a>
<FONT color="green">355</FONT>      public String getSensorDataIndex() {<a name="line.355"></a>
<FONT color="green">356</FONT>        String st = "SELECT XmlSensorDataRef FROM SensorData";<a name="line.356"></a>
<FONT color="green">357</FONT>        return getIndex("SensorData", st); //NOPMD  (See below)<a name="line.357"></a>
<FONT color="green">358</FONT>      }<a name="line.358"></a>
<FONT color="green">359</FONT>      <a name="line.359"></a>
<FONT color="green">360</FONT>      /*<a name="line.360"></a>
<FONT color="green">361</FONT>       * Interestingly, I could not refactor out the string "SensorData" to avoid the PMD error<a name="line.361"></a>
<FONT color="green">362</FONT>       * resulting from multiple occurrences of the same string. <a name="line.362"></a>
<FONT color="green">363</FONT>       * This is because if I made it a private String, then Findbugs would throw a warning asking<a name="line.363"></a>
<FONT color="green">364</FONT>       * for it to be static:<a name="line.364"></a>
<FONT color="green">365</FONT>       * <a name="line.365"></a>
<FONT color="green">366</FONT>       * private static final String sensorData = "SensorData"; <a name="line.366"></a>
<FONT color="green">367</FONT>       * <a name="line.367"></a>
<FONT color="green">368</FONT>       *  However, the above declaration causes the system to deadlock! <a name="line.368"></a>
<FONT color="green">369</FONT>       *  So, I'm just ignoring the PMD error. <a name="line.369"></a>
<FONT color="green">370</FONT>       */<a name="line.370"></a>
<FONT color="green">371</FONT>      <a name="line.371"></a>
<FONT color="green">372</FONT>      /** {@inheritDoc} */<a name="line.372"></a>
<FONT color="green">373</FONT>      @Override<a name="line.373"></a>
<FONT color="green">374</FONT>      public String getSensorDataIndex(User user) {<a name="line.374"></a>
<FONT color="green">375</FONT>        String st = "SELECT XmlSensorDataRef FROM SensorData WHERE owner='" + user.getEmail() + "'"; <a name="line.375"></a>
<FONT color="green">376</FONT>        return getIndex("SensorData", st);<a name="line.376"></a>
<FONT color="green">377</FONT>      }<a name="line.377"></a>
<FONT color="green">378</FONT>    <a name="line.378"></a>
<FONT color="green">379</FONT>      /** {@inheritDoc} */<a name="line.379"></a>
<FONT color="green">380</FONT>      @Override<a name="line.380"></a>
<FONT color="green">381</FONT>      public String getSensorDataIndex(User user, String sdtName) {<a name="line.381"></a>
<FONT color="green">382</FONT>        String st = <a name="line.382"></a>
<FONT color="green">383</FONT>          selectPrefix<a name="line.383"></a>
<FONT color="green">384</FONT>          + ownerEquals + user.getEmail() + quoteAndClause<a name="line.384"></a>
<FONT color="green">385</FONT>          + " Sdt='" + sdtName + "'"<a name="line.385"></a>
<FONT color="green">386</FONT>          + orderByTstamp;<a name="line.386"></a>
<FONT color="green">387</FONT>        return getIndex("SensorData", st);<a name="line.387"></a>
<FONT color="green">388</FONT>      }<a name="line.388"></a>
<FONT color="green">389</FONT>      <a name="line.389"></a>
<FONT color="green">390</FONT>      /** {@inheritDoc} */<a name="line.390"></a>
<FONT color="green">391</FONT>      @Override<a name="line.391"></a>
<FONT color="green">392</FONT>      public String getSensorDataIndex(List&lt;User&gt; users, XMLGregorianCalendar startTime, <a name="line.392"></a>
<FONT color="green">393</FONT>          XMLGregorianCalendar endTime, List&lt;String&gt; uriPatterns, String sdt) {<a name="line.393"></a>
<FONT color="green">394</FONT>        String statement;<a name="line.394"></a>
<FONT color="green">395</FONT>        if (sdt == null) { // Retrieve sensor data of all SDTs <a name="line.395"></a>
<FONT color="green">396</FONT>          statement =<a name="line.396"></a>
<FONT color="green">397</FONT>            selectPrefix<a name="line.397"></a>
<FONT color="green">398</FONT>            + constructOwnerClause(users)<a name="line.398"></a>
<FONT color="green">399</FONT>            + andClause <a name="line.399"></a>
<FONT color="green">400</FONT>            + " (Tstamp BETWEEN TIMESTAMP('" + Tstamp.makeTimestamp(startTime) + "') AND " //NOPMD<a name="line.400"></a>
<FONT color="green">401</FONT>            + " TIMESTAMP('" + Tstamp.makeTimestamp(endTime) + "'))" //NOPMD<a name="line.401"></a>
<FONT color="green">402</FONT>            + constructLikeClauses(uriPatterns)<a name="line.402"></a>
<FONT color="green">403</FONT>            + orderByTstamp;<a name="line.403"></a>
<FONT color="green">404</FONT>        }<a name="line.404"></a>
<FONT color="green">405</FONT>        else { // Retrieve sensor data of the specified SDT.<a name="line.405"></a>
<FONT color="green">406</FONT>          statement = <a name="line.406"></a>
<FONT color="green">407</FONT>            selectPrefix<a name="line.407"></a>
<FONT color="green">408</FONT>            + constructOwnerClause(users)<a name="line.408"></a>
<FONT color="green">409</FONT>            + andClause  <a name="line.409"></a>
<FONT color="green">410</FONT>            + sdtEquals + sdt + quoteAndClause <a name="line.410"></a>
<FONT color="green">411</FONT>            + " (Tstamp BETWEEN TIMESTAMP('" + Tstamp.makeTimestamp(startTime) + "') AND " //NOPMD<a name="line.411"></a>
<FONT color="green">412</FONT>            + " TIMESTAMP('" + Tstamp.makeTimestamp(endTime) + "'))" //NOPMD<a name="line.412"></a>
<FONT color="green">413</FONT>            + constructLikeClauses(uriPatterns)<a name="line.413"></a>
<FONT color="green">414</FONT>            + orderByTstamp;<a name="line.414"></a>
<FONT color="green">415</FONT>        }<a name="line.415"></a>
<FONT color="green">416</FONT>        //System.out.println(statement);<a name="line.416"></a>
<FONT color="green">417</FONT>        return getIndex("SensorData", statement);<a name="line.417"></a>
<FONT color="green">418</FONT>      }<a name="line.418"></a>
<FONT color="green">419</FONT>      <a name="line.419"></a>
<FONT color="green">420</FONT>      /** {@inheritDoc} */<a name="line.420"></a>
<FONT color="green">421</FONT>      @Override<a name="line.421"></a>
<FONT color="green">422</FONT>      public String getSensorDataIndex(List&lt;User&gt; users, XMLGregorianCalendar startTime, <a name="line.422"></a>
<FONT color="green">423</FONT>          XMLGregorianCalendar endTime, List&lt;String&gt; uriPatterns, String sdt, String tool) {<a name="line.423"></a>
<FONT color="green">424</FONT>        String statement =<a name="line.424"></a>
<FONT color="green">425</FONT>            selectPrefix<a name="line.425"></a>
<FONT color="green">426</FONT>            + constructOwnerClause(users)<a name="line.426"></a>
<FONT color="green">427</FONT>            + andClause  <a name="line.427"></a>
<FONT color="green">428</FONT>            + sdtEquals + sdt + quoteAndClause <a name="line.428"></a>
<FONT color="green">429</FONT>            + toolEquals + tool + quoteAndClause <a name="line.429"></a>
<FONT color="green">430</FONT>            + " (Tstamp BETWEEN TIMESTAMP('" + Tstamp.makeTimestamp(startTime) + "') AND " //NOPMD<a name="line.430"></a>
<FONT color="green">431</FONT>            + " TIMESTAMP('" + Tstamp.makeTimestamp(endTime) + "'))" //NOPMD<a name="line.431"></a>
<FONT color="green">432</FONT>            + constructLikeClauses(uriPatterns)<a name="line.432"></a>
<FONT color="green">433</FONT>            + orderByTstamp;<a name="line.433"></a>
<FONT color="green">434</FONT>        //System.out.println(statement);<a name="line.434"></a>
<FONT color="green">435</FONT>        return getIndex("SensorData", statement);<a name="line.435"></a>
<FONT color="green">436</FONT>      }<a name="line.436"></a>
<FONT color="green">437</FONT>      <a name="line.437"></a>
<FONT color="green">438</FONT>      /** {@inheritDoc} */<a name="line.438"></a>
<FONT color="green">439</FONT>      @Override<a name="line.439"></a>
<FONT color="green">440</FONT>      public String getProjectSensorDataSnapshot(List&lt;User&gt; users, XMLGregorianCalendar startTime, <a name="line.440"></a>
<FONT color="green">441</FONT>          XMLGregorianCalendar endTime, List&lt;String&gt; uriPatterns, String sdt, String tool) {<a name="line.441"></a>
<FONT color="green">442</FONT>        String statement;<a name="line.442"></a>
<FONT color="green">443</FONT>        if (tool == null) { // Retrieve sensor data with latest runtime regardless of tool.<a name="line.443"></a>
<FONT color="green">444</FONT>          statement =<a name="line.444"></a>
<FONT color="green">445</FONT>            selectSnapshot<a name="line.445"></a>
<FONT color="green">446</FONT>            + constructOwnerClause(users)<a name="line.446"></a>
<FONT color="green">447</FONT>            + andClause <a name="line.447"></a>
<FONT color="green">448</FONT>            + sdtEquals + sdt + quoteAndClause <a name="line.448"></a>
<FONT color="green">449</FONT>            + " (Tstamp BETWEEN TIMESTAMP('" + Tstamp.makeTimestamp(startTime) + "') AND " //NOPMD<a name="line.449"></a>
<FONT color="green">450</FONT>            + " TIMESTAMP('" + Tstamp.makeTimestamp(endTime) + "'))" //NOPMD<a name="line.450"></a>
<FONT color="green">451</FONT>            + constructLikeClauses(uriPatterns)<a name="line.451"></a>
<FONT color="green">452</FONT>            + orderByRuntime;<a name="line.452"></a>
<FONT color="green">453</FONT>        }<a name="line.453"></a>
<FONT color="green">454</FONT>        else { // Retrieve sensor data with the latest runtime for the specified tool.<a name="line.454"></a>
<FONT color="green">455</FONT>          statement = <a name="line.455"></a>
<FONT color="green">456</FONT>            selectSnapshot<a name="line.456"></a>
<FONT color="green">457</FONT>            + constructOwnerClause(users)<a name="line.457"></a>
<FONT color="green">458</FONT>            + andClause  <a name="line.458"></a>
<FONT color="green">459</FONT>            + sdtEquals + sdt + quoteAndClause <a name="line.459"></a>
<FONT color="green">460</FONT>            + toolEquals + tool + quoteAndClause <a name="line.460"></a>
<FONT color="green">461</FONT>            + " (Tstamp BETWEEN TIMESTAMP('" + Tstamp.makeTimestamp(startTime) + "') AND " //NOPMD<a name="line.461"></a>
<FONT color="green">462</FONT>            + " TIMESTAMP('" + Tstamp.makeTimestamp(endTime) + "'))" //NOPMD<a name="line.462"></a>
<FONT color="green">463</FONT>            + constructLikeClauses(uriPatterns)<a name="line.463"></a>
<FONT color="green">464</FONT>            + orderByRuntime;<a name="line.464"></a>
<FONT color="green">465</FONT>        }<a name="line.465"></a>
<FONT color="green">466</FONT>        //Generate a SensorDataIndex string that contains only entries with the latest runtime.<a name="line.466"></a>
<FONT color="green">467</FONT>        //System.out.println(statement);<a name="line.467"></a>
<FONT color="green">468</FONT>        return getSnapshotIndex(statement);<a name="line.468"></a>
<FONT color="green">469</FONT>      }<a name="line.469"></a>
<FONT color="green">470</FONT>      <a name="line.470"></a>
<FONT color="green">471</FONT>      /** {@inheritDoc} */<a name="line.471"></a>
<FONT color="green">472</FONT>      @Override<a name="line.472"></a>
<FONT color="green">473</FONT>      public String getSensorDataIndex(List&lt;User&gt; users, XMLGregorianCalendar startTime, <a name="line.473"></a>
<FONT color="green">474</FONT>          XMLGregorianCalendar endTime, List&lt;String&gt; uriPatterns, int startIndex, <a name="line.474"></a>
<FONT color="green">475</FONT>          int maxInstances) {<a name="line.475"></a>
<FONT color="green">476</FONT>        String statement;<a name="line.476"></a>
<FONT color="green">477</FONT>    <a name="line.477"></a>
<FONT color="green">478</FONT>        statement =<a name="line.478"></a>
<FONT color="green">479</FONT>            selectPrefix<a name="line.479"></a>
<FONT color="green">480</FONT>            + constructOwnerClause(users)<a name="line.480"></a>
<FONT color="green">481</FONT>            + andClause <a name="line.481"></a>
<FONT color="green">482</FONT>            + " (Tstamp BETWEEN TIMESTAMP('" + Tstamp.makeTimestamp(startTime) + "') AND " //NOPMD<a name="line.482"></a>
<FONT color="green">483</FONT>            + " TIMESTAMP('" + Tstamp.makeTimestamp(endTime) + "'))" //NOPMD<a name="line.483"></a>
<FONT color="green">484</FONT>            + constructLikeClauses(uriPatterns)<a name="line.484"></a>
<FONT color="green">485</FONT>            + orderByTstamp;<a name="line.485"></a>
<FONT color="green">486</FONT>        //System.out.println(statement);<a name="line.486"></a>
<FONT color="green">487</FONT>        return getIndex("SensorData", statement, startIndex, maxInstances);<a name="line.487"></a>
<FONT color="green">488</FONT>      }<a name="line.488"></a>
<FONT color="green">489</FONT>      <a name="line.489"></a>
<FONT color="green">490</FONT>      /**<a name="line.490"></a>
<FONT color="green">491</FONT>       * Constructs a set of LIKE clauses corresponding to the passed set of UriPatterns.<a name="line.491"></a>
<FONT color="green">492</FONT>       * &lt;p&gt;<a name="line.492"></a>
<FONT color="green">493</FONT>       * Each UriPattern is translated in the following way:<a name="line.493"></a>
<FONT color="green">494</FONT>       * &lt;ul&gt;<a name="line.494"></a>
<FONT color="green">495</FONT>       * &lt;li&gt; If there is an occurrence of a "\" or a "/" in the UriPattern, then <a name="line.495"></a>
<FONT color="green">496</FONT>       * two translated UriPatterns are generated, one with all "\" replaced with "/", and one with <a name="line.496"></a>
<FONT color="green">497</FONT>       * all "/" replaced with "\".<a name="line.497"></a>
<FONT color="green">498</FONT>       * &lt;li&gt; The escape character is "\", unless we are generating a LIKE clause containing a <a name="line.498"></a>
<FONT color="green">499</FONT>       * "\", in which case the escape character will be "/".<a name="line.499"></a>
<FONT color="green">500</FONT>       * &lt;li&gt; All occurrences of "%" in the UriPattern are escaped.<a name="line.500"></a>
<FONT color="green">501</FONT>       * &lt;li&gt; All occurrences of "_" in the UriPattern are escaped.<a name="line.501"></a>
<FONT color="green">502</FONT>       * &lt;li&gt; All occurrences of "*" are changed to "%".<a name="line.502"></a>
<FONT color="green">503</FONT>       * &lt;/ul&gt;<a name="line.503"></a>
<FONT color="green">504</FONT>       * The new set of 'translated' UriPatterns are now used to generate a set of LIKE clauses<a name="line.504"></a>
<FONT color="green">505</FONT>       * with the following form:<a name="line.505"></a>
<FONT color="green">506</FONT>       * &lt;pre&gt;<a name="line.506"></a>
<FONT color="green">507</FONT>       * (RESOURCE like 'translatedUriPattern1' escape 'escapeChar1') OR<a name="line.507"></a>
<FONT color="green">508</FONT>       * (RESOURCE like 'translatedUriPattern2' escape 'escapeChar2') ..<a name="line.508"></a>
<FONT color="green">509</FONT>       * &lt;/pre&gt;<a name="line.509"></a>
<FONT color="green">510</FONT>       * <a name="line.510"></a>
<FONT color="green">511</FONT>       * &lt;p&gt;<a name="line.511"></a>
<FONT color="green">512</FONT>       * There is one special case.  If the List(UriPattern) is null, empty, or consists of exactly one <a name="line.512"></a>
<FONT color="green">513</FONT>       * UriPattern which is "**" or "*", then the empty string is returned. This is an optimization for<a name="line.513"></a>
<FONT color="green">514</FONT>       * the common case where all resources should be matched and so we don't need any LIKE clauses.<a name="line.514"></a>
<FONT color="green">515</FONT>       * &lt;p&gt;<a name="line.515"></a>
<FONT color="green">516</FONT>       * We return either the empty string (""), or else a string of the form:<a name="line.516"></a>
<FONT color="green">517</FONT>       * " AND ([like clause] AND [like clause] ... )"<a name="line.517"></a>
<FONT color="green">518</FONT>       * This enables the return value to be appended to the SELECT statement.<a name="line.518"></a>
<FONT color="green">519</FONT>       * &lt;p&gt;<a name="line.519"></a>
<FONT color="green">520</FONT>       * This method is static and package private to support testing. See the class <a name="line.520"></a>
<FONT color="green">521</FONT>       * TestConstructUriPattern for example invocations and expected return values. <a name="line.521"></a>
<FONT color="green">522</FONT>       *  <a name="line.522"></a>
<FONT color="green">523</FONT>       * @param uriPatterns The list of uriPatterns.<a name="line.523"></a>
<FONT color="green">524</FONT>       * @return The String to be used in the where clause to check for resource correctness.<a name="line.524"></a>
<FONT color="green">525</FONT>       */<a name="line.525"></a>
<FONT color="green">526</FONT>      static String constructLikeClauses(List&lt;String&gt; uriPatterns) {<a name="line.526"></a>
<FONT color="green">527</FONT>        // Deal with special case. UriPatterns is null, or empty, or "**", or "*"<a name="line.527"></a>
<FONT color="green">528</FONT>        if (((uriPatterns == null) || uriPatterns.isEmpty()) ||<a name="line.528"></a>
<FONT color="green">529</FONT>            ((uriPatterns.size() == 1) &amp;&amp; uriPatterns.get(0).equals("**")) ||<a name="line.529"></a>
<FONT color="green">530</FONT>            ((uriPatterns.size() == 1) &amp;&amp; uriPatterns.get(0).equals("*"))) {<a name="line.530"></a>
<FONT color="green">531</FONT>          return "";<a name="line.531"></a>
<FONT color="green">532</FONT>        }<a name="line.532"></a>
<FONT color="green">533</FONT>        // Deal with the potential presence of path separator character in UriPattern.<a name="line.533"></a>
<FONT color="green">534</FONT>        List&lt;String&gt; translatedPatterns = new ArrayList&lt;String&gt;();<a name="line.534"></a>
<FONT color="green">535</FONT>        for (String pattern : uriPatterns) {<a name="line.535"></a>
<FONT color="green">536</FONT>          if (pattern.contains("\\") || pattern.contains("/")) {<a name="line.536"></a>
<FONT color="green">537</FONT>            translatedPatterns.add(pattern.replace('\\', '/'));<a name="line.537"></a>
<FONT color="green">538</FONT>            translatedPatterns.add(pattern.replace('/', '\\'));<a name="line.538"></a>
<FONT color="green">539</FONT>          }<a name="line.539"></a>
<FONT color="green">540</FONT>          else {<a name="line.540"></a>
<FONT color="green">541</FONT>            translatedPatterns.add(pattern);<a name="line.541"></a>
<FONT color="green">542</FONT>          }        <a name="line.542"></a>
<FONT color="green">543</FONT>        }<a name="line.543"></a>
<FONT color="green">544</FONT>        // Now escape the SQL wildcards, and make our UriPattern wildcard into the SQL wildcard.<a name="line.544"></a>
<FONT color="green">545</FONT>        for (int i = 0; i &lt; translatedPatterns.size(); i++) {<a name="line.545"></a>
<FONT color="green">546</FONT>          String pattern = translatedPatterns.get(i);<a name="line.546"></a>
<FONT color="green">547</FONT>          pattern = pattern.replace("%", "`%"); // used to be /<a name="line.547"></a>
<FONT color="green">548</FONT>          pattern = pattern.replace("_", "`_"); // used to be /<a name="line.548"></a>
<FONT color="green">549</FONT>          pattern = pattern.replace('*', '%');<a name="line.549"></a>
<FONT color="green">550</FONT>          translatedPatterns.set(i, pattern);<a name="line.550"></a>
<FONT color="green">551</FONT>        }<a name="line.551"></a>
<FONT color="green">552</FONT>    <a name="line.552"></a>
<FONT color="green">553</FONT>        // Now generate the return string: " AND (&lt;like clause&gt; OR &lt;like clause&gt; ... )".<a name="line.553"></a>
<FONT color="green">554</FONT>        StringBuffer buff = new StringBuffer();<a name="line.554"></a>
<FONT color="green">555</FONT>        buff.append(" AND (");<a name="line.555"></a>
<FONT color="green">556</FONT>        if (!translatedPatterns.isEmpty()) {<a name="line.556"></a>
<FONT color="green">557</FONT>          buff.append(makeLikeClause(translatedPatterns, "`")); // used to be /<a name="line.557"></a>
<FONT color="green">558</FONT>        }<a name="line.558"></a>
<FONT color="green">559</FONT>    <a name="line.559"></a>
<FONT color="green">560</FONT>        buff.append(')');<a name="line.560"></a>
<FONT color="green">561</FONT>        <a name="line.561"></a>
<FONT color="green">562</FONT>        return buff.toString();<a name="line.562"></a>
<FONT color="green">563</FONT>      }<a name="line.563"></a>
<FONT color="green">564</FONT>      <a name="line.564"></a>
<FONT color="green">565</FONT>      /**<a name="line.565"></a>
<FONT color="green">566</FONT>       * Creates a set of LIKE clauses with the specified escape character.<a name="line.566"></a>
<FONT color="green">567</FONT>       * @param patterns The patterns. <a name="line.567"></a>
<FONT color="green">568</FONT>       * @param escape The escape character.<a name="line.568"></a>
<FONT color="green">569</FONT>       * @return The StringBuffer with the LIKE clauses. <a name="line.569"></a>
<FONT color="green">570</FONT>       */<a name="line.570"></a>
<FONT color="green">571</FONT>      private static StringBuffer makeLikeClause(List&lt;String&gt; patterns, String escape) {<a name="line.571"></a>
<FONT color="green">572</FONT>        StringBuffer buff = new StringBuffer(); //NOPMD generates false warning about buff size.<a name="line.572"></a>
<FONT color="green">573</FONT>        if (patterns.isEmpty()) {<a name="line.573"></a>
<FONT color="green">574</FONT>          return buff;<a name="line.574"></a>
<FONT color="green">575</FONT>        }<a name="line.575"></a>
<FONT color="green">576</FONT>        for (Iterator&lt;String&gt; i = patterns.iterator(); i.hasNext(); ) {<a name="line.576"></a>
<FONT color="green">577</FONT>          String pattern = i.next();<a name="line.577"></a>
<FONT color="green">578</FONT>          buff.append("(RESOURCE LIKE '");<a name="line.578"></a>
<FONT color="green">579</FONT>          buff.append(pattern);<a name="line.579"></a>
<FONT color="green">580</FONT>          buff.append("' ESCAPE '");<a name="line.580"></a>
<FONT color="green">581</FONT>          buff.append(escape);<a name="line.581"></a>
<FONT color="green">582</FONT>          buff.append("')");<a name="line.582"></a>
<FONT color="green">583</FONT>          if (i.hasNext()) {<a name="line.583"></a>
<FONT color="green">584</FONT>            buff.append(" OR ");<a name="line.584"></a>
<FONT color="green">585</FONT>          }<a name="line.585"></a>
<FONT color="green">586</FONT>        }<a name="line.586"></a>
<FONT color="green">587</FONT>        buff.append(' ');<a name="line.587"></a>
<FONT color="green">588</FONT>        return buff;<a name="line.588"></a>
<FONT color="green">589</FONT>      }<a name="line.589"></a>
<FONT color="green">590</FONT>      <a name="line.590"></a>
<FONT color="green">591</FONT>      /**<a name="line.591"></a>
<FONT color="green">592</FONT>       * Constructs a clause of form ( OWNER = 'user1' [ OR OWNER = 'user2']* ). <a name="line.592"></a>
<FONT color="green">593</FONT>       * @param users The list of users whose ownership is being searched for.<a name="line.593"></a>
<FONT color="green">594</FONT>       * @return The String to be used in the where clause to check for ownership.<a name="line.594"></a>
<FONT color="green">595</FONT>       */<a name="line.595"></a>
<FONT color="green">596</FONT>      private String constructOwnerClause(List&lt;User&gt; users) {<a name="line.596"></a>
<FONT color="green">597</FONT>        StringBuffer buff = new StringBuffer();<a name="line.597"></a>
<FONT color="green">598</FONT>        buff.append('(');<a name="line.598"></a>
<FONT color="green">599</FONT>        // Use old school iterator so we can do a hasNext() inside the loop.<a name="line.599"></a>
<FONT color="green">600</FONT>        for (Iterator&lt;User&gt; i = users.iterator(); i.hasNext(); ) {<a name="line.600"></a>
<FONT color="green">601</FONT>          User user = i.next();<a name="line.601"></a>
<FONT color="green">602</FONT>          buff.append(ownerEquals);<a name="line.602"></a>
<FONT color="green">603</FONT>          buff.append(user.getEmail());<a name="line.603"></a>
<FONT color="green">604</FONT>          buff.append('\'');<a name="line.604"></a>
<FONT color="green">605</FONT>          if (i.hasNext()) {<a name="line.605"></a>
<FONT color="green">606</FONT>            buff.append(" OR");<a name="line.606"></a>
<FONT color="green">607</FONT>          }<a name="line.607"></a>
<FONT color="green">608</FONT>        }<a name="line.608"></a>
<FONT color="green">609</FONT>        buff.append(") ");<a name="line.609"></a>
<FONT color="green">610</FONT>        return buff.toString();<a name="line.610"></a>
<FONT color="green">611</FONT>      }<a name="line.611"></a>
<FONT color="green">612</FONT>      <a name="line.612"></a>
<FONT color="green">613</FONT>      /** {@inheritDoc} */<a name="line.613"></a>
<FONT color="green">614</FONT>      @Override<a name="line.614"></a>
<FONT color="green">615</FONT>      public String getSensorDataIndexLastMod(User user, XMLGregorianCalendar lastModStartTime,<a name="line.615"></a>
<FONT color="green">616</FONT>          XMLGregorianCalendar lastModEndTime) {<a name="line.616"></a>
<FONT color="green">617</FONT>        String statement = <a name="line.617"></a>
<FONT color="green">618</FONT>          selectPrefix<a name="line.618"></a>
<FONT color="green">619</FONT>          + ownerEquals + user.getEmail() + quoteAndClause <a name="line.619"></a>
<FONT color="green">620</FONT>          + " LastMod BETWEEN TIMESTAMP('" + Tstamp.makeTimestamp(lastModStartTime) + "') AND "<a name="line.620"></a>
<FONT color="green">621</FONT>          + " TIMESTAMP('" + Tstamp.makeTimestamp(lastModEndTime) + "')";<a name="line.621"></a>
<FONT color="green">622</FONT>        return getIndex("SensorData", statement);<a name="line.622"></a>
<FONT color="green">623</FONT>      }<a name="line.623"></a>
<FONT color="green">624</FONT>      <a name="line.624"></a>
<FONT color="green">625</FONT>    <a name="line.625"></a>
<FONT color="green">626</FONT>      /** {@inheritDoc} */<a name="line.626"></a>
<FONT color="green">627</FONT>      @Override<a name="line.627"></a>
<FONT color="green">628</FONT>      public boolean hasSensorData(User user, XMLGregorianCalendar timestamp) {<a name="line.628"></a>
<FONT color="green">629</FONT>        Connection conn = null;<a name="line.629"></a>
<FONT color="green">630</FONT>        PreparedStatement s = null;<a name="line.630"></a>
<FONT color="green">631</FONT>        ResultSet rs = null;<a name="line.631"></a>
<FONT color="green">632</FONT>        boolean isFound = false;<a name="line.632"></a>
<FONT color="green">633</FONT>        try {<a name="line.633"></a>
<FONT color="green">634</FONT>          conn = DriverManager.getConnection(connectionURL);<a name="line.634"></a>
<FONT color="green">635</FONT>          // <a name="line.635"></a>
<FONT color="green">636</FONT>          String statement = <a name="line.636"></a>
<FONT color="green">637</FONT>            selectPrefix<a name="line.637"></a>
<FONT color="green">638</FONT>            + ownerEquals + user.getEmail() + quoteAndClause <a name="line.638"></a>
<FONT color="green">639</FONT>            + " Tstamp='" + Tstamp.makeTimestamp(timestamp) + "'";<a name="line.639"></a>
<FONT color="green">640</FONT>          server.getLogger().fine(executeQueryMsg + statement);<a name="line.640"></a>
<FONT color="green">641</FONT>          s = conn.prepareStatement(statement);<a name="line.641"></a>
<FONT color="green">642</FONT>          rs = s.executeQuery();<a name="line.642"></a>
<FONT color="green">643</FONT>          // If a record was retrieved, we'll enter the loop, otherwise we won't. <a name="line.643"></a>
<FONT color="green">644</FONT>          while (rs.next()) {<a name="line.644"></a>
<FONT color="green">645</FONT>            isFound = true;<a name="line.645"></a>
<FONT color="green">646</FONT>          }<a name="line.646"></a>
<FONT color="green">647</FONT>        }<a name="line.647"></a>
<FONT color="green">648</FONT>        catch (SQLException e) {<a name="line.648"></a>
<FONT color="green">649</FONT>          this.logger.info("Derby: Error in hasSensorData()" + StackTrace.toString(e));<a name="line.649"></a>
<FONT color="green">650</FONT>        }<a name="line.650"></a>
<FONT color="green">651</FONT>        finally {<a name="line.651"></a>
<FONT color="green">652</FONT>          try {<a name="line.652"></a>
<FONT color="green">653</FONT>            rs.close();<a name="line.653"></a>
<FONT color="green">654</FONT>            s.close();<a name="line.654"></a>
<FONT color="green">655</FONT>            conn.close();<a name="line.655"></a>
<FONT color="green">656</FONT>          }<a name="line.656"></a>
<FONT color="green">657</FONT>          catch (SQLException e) {<a name="line.657"></a>
<FONT color="green">658</FONT>            this.logger.warning("Derby: Error closing the connection" + StackTrace.toString(e));<a name="line.658"></a>
<FONT color="green">659</FONT>          }<a name="line.659"></a>
<FONT color="green">660</FONT>        }<a name="line.660"></a>
<FONT color="green">661</FONT>        return isFound;<a name="line.661"></a>
<FONT color="green">662</FONT>      }<a name="line.662"></a>
<FONT color="green">663</FONT>    <a name="line.663"></a>
<FONT color="green">664</FONT>      /** {@inheritDoc} */<a name="line.664"></a>
<FONT color="green">665</FONT>      @Override<a name="line.665"></a>
<FONT color="green">666</FONT>      public void deleteSensorData(User user, XMLGregorianCalendar timestamp) {<a name="line.666"></a>
<FONT color="green">667</FONT>        String statement =<a name="line.667"></a>
<FONT color="green">668</FONT>          "DELETE FROM SensorData WHERE "<a name="line.668"></a>
<FONT color="green">669</FONT>          + ownerEquals + user.getEmail() + quoteAndClause <a name="line.669"></a>
<FONT color="green">670</FONT>          + " Tstamp='" + Tstamp.makeTimestamp(timestamp) + "'";<a name="line.670"></a>
<FONT color="green">671</FONT>        deleteResource(statement);<a name="line.671"></a>
<FONT color="green">672</FONT>      }<a name="line.672"></a>
<FONT color="green">673</FONT>      <a name="line.673"></a>
<FONT color="green">674</FONT>      /** {@inheritDoc} */<a name="line.674"></a>
<FONT color="green">675</FONT>      @Override<a name="line.675"></a>
<FONT color="green">676</FONT>      public void deleteSensorData(User user) {<a name="line.676"></a>
<FONT color="green">677</FONT>        String statement =<a name="line.677"></a>
<FONT color="green">678</FONT>          "DELETE FROM SensorData WHERE " + ownerEquals + user.getEmail() + "'";<a name="line.678"></a>
<FONT color="green">679</FONT>        deleteResource(statement);<a name="line.679"></a>
<FONT color="green">680</FONT>        //compressTables();  // this should be done separately as part of some maintenance. <a name="line.680"></a>
<FONT color="green">681</FONT>      }<a name="line.681"></a>
<FONT color="green">682</FONT>    <a name="line.682"></a>
<FONT color="green">683</FONT>      /** {@inheritDoc} */<a name="line.683"></a>
<FONT color="green">684</FONT>      @Override<a name="line.684"></a>
<FONT color="green">685</FONT>      public String getSensorData(User user, XMLGregorianCalendar timestamp) {<a name="line.685"></a>
<FONT color="green">686</FONT>        String statement =<a name="line.686"></a>
<FONT color="green">687</FONT>          "SELECT XmlSensorData FROM SensorData WHERE "<a name="line.687"></a>
<FONT color="green">688</FONT>          + ownerEquals + user.getEmail() + quoteAndClause <a name="line.688"></a>
<FONT color="green">689</FONT>          + " Tstamp='" + Tstamp.makeTimestamp(timestamp) + "'";<a name="line.689"></a>
<FONT color="green">690</FONT>        return getResource("SensorData", statement); <a name="line.690"></a>
<FONT color="green">691</FONT>      }<a name="line.691"></a>
<FONT color="green">692</FONT>    <a name="line.692"></a>
<FONT color="green">693</FONT>      // ********************   Start SensorDataType specific stuff here *****************  //<a name="line.693"></a>
<FONT color="green">694</FONT>    <a name="line.694"></a>
<FONT color="green">695</FONT>      /** The SQL string for creating the SensorDataType table. */<a name="line.695"></a>
<FONT color="green">696</FONT>      private static final String createSensorDataTypeTableStatement = <a name="line.696"></a>
<FONT color="green">697</FONT>        "create table SensorDataType  "<a name="line.697"></a>
<FONT color="green">698</FONT>        + "("<a name="line.698"></a>
<FONT color="green">699</FONT>        + " Name VARCHAR(64) NOT NULL, "<a name="line.699"></a>
<FONT color="green">700</FONT>        + " XmlSensorDataType VARCHAR(32000) NOT NULL, "<a name="line.700"></a>
<FONT color="green">701</FONT>        + " XmlSensorDataTypeRef VARCHAR(1000) NOT NULL, "<a name="line.701"></a>
<FONT color="green">702</FONT>        + " LastMod TIMESTAMP NOT NULL, "<a name="line.702"></a>
<FONT color="green">703</FONT>        + " PRIMARY KEY (Name) "<a name="line.703"></a>
<FONT color="green">704</FONT>        + ")" ;<a name="line.704"></a>
<FONT color="green">705</FONT>      <a name="line.705"></a>
<FONT color="green">706</FONT>      /** An SQL string to test whether the SensorDataType table exists and has the correct schema. */<a name="line.706"></a>
<FONT color="green">707</FONT>      private static final String testSensorDataTypeTableStatement = <a name="line.707"></a>
<FONT color="green">708</FONT>        " UPDATE SensorDataType SET "<a name="line.708"></a>
<FONT color="green">709</FONT>        + " Name = 'TestSdt', " <a name="line.709"></a>
<FONT color="green">710</FONT>        + " XmlSensorDataType = 'testXmlResource', "<a name="line.710"></a>
<FONT color="green">711</FONT>        + " XmlSensorDataTypeRef = 'testXmlRef', "<a name="line.711"></a>
<FONT color="green">712</FONT>        + " LastMod = '" + new Timestamp(new Date().getTime()).toString() + "' "<a name="line.712"></a>
<FONT color="green">713</FONT>        + " WHERE 1=3";<a name="line.713"></a>
<FONT color="green">714</FONT>    <a name="line.714"></a>
<FONT color="green">715</FONT>      /** {@inheritDoc} */<a name="line.715"></a>
<FONT color="green">716</FONT>      @Override<a name="line.716"></a>
<FONT color="green">717</FONT>      public boolean storeSensorDataType(SensorDataType sdt, String xmlSensorDataType, <a name="line.717"></a>
<FONT color="green">718</FONT>          String xmlSensorDataTypeRef) {<a name="line.718"></a>
<FONT color="green">719</FONT>        Connection conn = null;<a name="line.719"></a>
<FONT color="green">720</FONT>        PreparedStatement s = null;<a name="line.720"></a>
<FONT color="green">721</FONT>        try {<a name="line.721"></a>
<FONT color="green">722</FONT>          conn = DriverManager.getConnection(connectionURL);<a name="line.722"></a>
<FONT color="green">723</FONT>          s = conn.prepareStatement("INSERT INTO SensorDataType VALUES (?, ?, ?, ?)");<a name="line.723"></a>
<FONT color="green">724</FONT>          // Order: Name XmlSensorData XmlSensorDataRef LastMod<a name="line.724"></a>
<FONT color="green">725</FONT>          s.setString(1, sdt.getName());<a name="line.725"></a>
<FONT color="green">726</FONT>          s.setString(2, xmlSensorDataType);<a name="line.726"></a>
<FONT color="green">727</FONT>          s.setString(3, xmlSensorDataTypeRef);<a name="line.727"></a>
<FONT color="green">728</FONT>          s.setTimestamp(4, new Timestamp(new Date().getTime()));<a name="line.728"></a>
<FONT color="green">729</FONT>          s.executeUpdate();<a name="line.729"></a>
<FONT color="green">730</FONT>          this.logger.fine("Derby: Inserted SDT" + sdt.getName());<a name="line.730"></a>
<FONT color="green">731</FONT>        }<a name="line.731"></a>
<FONT color="green">732</FONT>        catch (SQLException e) {<a name="line.732"></a>
<FONT color="green">733</FONT>          if (DUPLICATE_KEY.equals(e.getSQLState())) {<a name="line.733"></a>
<FONT color="green">734</FONT>            try {<a name="line.734"></a>
<FONT color="green">735</FONT>              // Do an update, not an insert.<a name="line.735"></a>
<FONT color="green">736</FONT>              s = conn.prepareStatement(<a name="line.736"></a>
<FONT color="green">737</FONT>                  "UPDATE SensorDataType SET "<a name="line.737"></a>
<FONT color="green">738</FONT>                  + " XmlSensorDataType=?, " <a name="line.738"></a>
<FONT color="green">739</FONT>                  + " XmlSensorDataTypeRef=?, "<a name="line.739"></a>
<FONT color="green">740</FONT>                  + " LastMod=?"<a name="line.740"></a>
<FONT color="green">741</FONT>                  + " WHERE Name=?");<a name="line.741"></a>
<FONT color="green">742</FONT>              s.setString(1, xmlSensorDataType);<a name="line.742"></a>
<FONT color="green">743</FONT>              s.setString(2, xmlSensorDataTypeRef);<a name="line.743"></a>
<FONT color="green">744</FONT>              s.setTimestamp(3, new Timestamp(new Date().getTime()));<a name="line.744"></a>
<FONT color="green">745</FONT>              s.setString(4, sdt.getName());<a name="line.745"></a>
<FONT color="green">746</FONT>              s.executeUpdate();<a name="line.746"></a>
<FONT color="green">747</FONT>              this.logger.fine("Derby: Updated SDT " + sdt.getName());<a name="line.747"></a>
<FONT color="green">748</FONT>            }<a name="line.748"></a>
<FONT color="green">749</FONT>            catch (SQLException f) {<a name="line.749"></a>
<FONT color="green">750</FONT>              this.logger.info(derbyError + StackTrace.toString(f));<a name="line.750"></a>
<FONT color="green">751</FONT>            }<a name="line.751"></a>
<FONT color="green">752</FONT>          }<a name="line.752"></a>
<FONT color="green">753</FONT>        }<a name="line.753"></a>
<FONT color="green">754</FONT>        finally {<a name="line.754"></a>
<FONT color="green">755</FONT>          try {<a name="line.755"></a>
<FONT color="green">756</FONT>            s.close();<a name="line.756"></a>
<FONT color="green">757</FONT>            conn.close();<a name="line.757"></a>
<FONT color="green">758</FONT>          }<a name="line.758"></a>
<FONT color="green">759</FONT>          catch (SQLException e) {<a name="line.759"></a>
<FONT color="green">760</FONT>            this.logger.warning(errorClosingMsg + StackTrace.toString(e));<a name="line.760"></a>
<FONT color="green">761</FONT>          }<a name="line.761"></a>
<FONT color="green">762</FONT>        }<a name="line.762"></a>
<FONT color="green">763</FONT>        return true;<a name="line.763"></a>
<FONT color="green">764</FONT>      }<a name="line.764"></a>
<FONT color="green">765</FONT>    <a name="line.765"></a>
<FONT color="green">766</FONT>      /** {@inheritDoc} */<a name="line.766"></a>
<FONT color="green">767</FONT>      @Override<a name="line.767"></a>
<FONT color="green">768</FONT>      public void deleteSensorDataType(String sdtName) {<a name="line.768"></a>
<FONT color="green">769</FONT>        String statement = "DELETE FROM SensorDataType WHERE Name='" + sdtName + "'";<a name="line.769"></a>
<FONT color="green">770</FONT>        deleteResource(statement);<a name="line.770"></a>
<FONT color="green">771</FONT>      }<a name="line.771"></a>
<FONT color="green">772</FONT>    <a name="line.772"></a>
<FONT color="green">773</FONT>      /** {@inheritDoc} */<a name="line.773"></a>
<FONT color="green">774</FONT>      @Override<a name="line.774"></a>
<FONT color="green">775</FONT>      public String getSensorDataTypeIndex() {<a name="line.775"></a>
<FONT color="green">776</FONT>        return getIndex("SensorDataType", "SELECT XmlSensorDataTypeRef FROM SensorDataType");<a name="line.776"></a>
<FONT color="green">777</FONT>      }<a name="line.777"></a>
<FONT color="green">778</FONT>    <a name="line.778"></a>
<FONT color="green">779</FONT>      /** {@inheritDoc} */<a name="line.779"></a>
<FONT color="green">780</FONT>      @Override<a name="line.780"></a>
<FONT color="green">781</FONT>      public String getSensorDataType(String sdtName) {<a name="line.781"></a>
<FONT color="green">782</FONT>        String statement = <a name="line.782"></a>
<FONT color="green">783</FONT>          "SELECT XmlSensorDataType FROM SensorDataType WHERE Name = '" + sdtName + "'";<a name="line.783"></a>
<FONT color="green">784</FONT>        return getResource("SensorDataType", statement);<a name="line.784"></a>
<FONT color="green">785</FONT>      }<a name="line.785"></a>
<FONT color="green">786</FONT>      <a name="line.786"></a>
<FONT color="green">787</FONT>      // ********************   Start  User specific stuff here *****************  //<a name="line.787"></a>
<FONT color="green">788</FONT>      /** The SQL string for creating the HackyUser table. So named because 'User' is reserved. */<a name="line.788"></a>
<FONT color="green">789</FONT>      private static final String createUserTableStatement = <a name="line.789"></a>
<FONT color="green">790</FONT>        "create table HackyUser  "<a name="line.790"></a>
<FONT color="green">791</FONT>        + "("<a name="line.791"></a>
<FONT color="green">792</FONT>        + " Email VARCHAR(128) NOT NULL, "<a name="line.792"></a>
<FONT color="green">793</FONT>        + " Password VARCHAR(128) NOT NULL, "<a name="line.793"></a>
<FONT color="green">794</FONT>        + " Role CHAR(16), "<a name="line.794"></a>
<FONT color="green">795</FONT>        + " XmlUser VARCHAR(32000) NOT NULL, "<a name="line.795"></a>
<FONT color="green">796</FONT>        + " XmlUserRef VARCHAR(1000) NOT NULL, "<a name="line.796"></a>
<FONT color="green">797</FONT>        + " LastMod TIMESTAMP NOT NULL, "<a name="line.797"></a>
<FONT color="green">798</FONT>        + " PRIMARY KEY (Email) "<a name="line.798"></a>
<FONT color="green">799</FONT>        + ")" ;<a name="line.799"></a>
<FONT color="green">800</FONT>      <a name="line.800"></a>
<FONT color="green">801</FONT>      /** An SQL string to test whether the User table exists and has the correct schema. */<a name="line.801"></a>
<FONT color="green">802</FONT>      private static final String testUserTableStatement = <a name="line.802"></a>
<FONT color="green">803</FONT>        " UPDATE HackyUser SET "<a name="line.803"></a>
<FONT color="green">804</FONT>        + " Email = 'TestEmail@foo.com', " <a name="line.804"></a>
<FONT color="green">805</FONT>        + " Password = 'changeme', " <a name="line.805"></a>
<FONT color="green">806</FONT>        + " Role = 'basic', " <a name="line.806"></a>
<FONT color="green">807</FONT>        + " XmlUser = 'testXmlResource', "<a name="line.807"></a>
<FONT color="green">808</FONT>        + " XmlUserRef = 'testXmlRef', "<a name="line.808"></a>
<FONT color="green">809</FONT>        + " LastMod = '" + new Timestamp(new Date().getTime()).toString() + "' "<a name="line.809"></a>
<FONT color="green">810</FONT>        + " WHERE 1=3";<a name="line.810"></a>
<FONT color="green">811</FONT>    <a name="line.811"></a>
<FONT color="green">812</FONT>      /** {@inheritDoc} */<a name="line.812"></a>
<FONT color="green">813</FONT>      @Override<a name="line.813"></a>
<FONT color="green">814</FONT>      public void deleteUser(String email) {<a name="line.814"></a>
<FONT color="green">815</FONT>        String statement = "DELETE FROM HackyUser WHERE Email='" + email + "'";<a name="line.815"></a>
<FONT color="green">816</FONT>        deleteResource(statement);<a name="line.816"></a>
<FONT color="green">817</FONT>      }<a name="line.817"></a>
<FONT color="green">818</FONT>    <a name="line.818"></a>
<FONT color="green">819</FONT>      /** {@inheritDoc} */<a name="line.819"></a>
<FONT color="green">820</FONT>      @Override<a name="line.820"></a>
<FONT color="green">821</FONT>      public String getUser(String email) {<a name="line.821"></a>
<FONT color="green">822</FONT>        String statement = "SELECT XmlUser FROM HackyUser WHERE Email = '" + email + "'";<a name="line.822"></a>
<FONT color="green">823</FONT>        return getResource("User", statement);<a name="line.823"></a>
<FONT color="green">824</FONT>      }<a name="line.824"></a>
<FONT color="green">825</FONT>    <a name="line.825"></a>
<FONT color="green">826</FONT>    <a name="line.826"></a>
<FONT color="green">827</FONT>      /** {@inheritDoc} */<a name="line.827"></a>
<FONT color="green">828</FONT>      @Override<a name="line.828"></a>
<FONT color="green">829</FONT>      public String getUserIndex() {<a name="line.829"></a>
<FONT color="green">830</FONT>        return getIndex("User", "SELECT XmlUserRef FROM HackyUser");<a name="line.830"></a>
<FONT color="green">831</FONT>      }<a name="line.831"></a>
<FONT color="green">832</FONT>    <a name="line.832"></a>
<FONT color="green">833</FONT>      /** {@inheritDoc} */<a name="line.833"></a>
<FONT color="green">834</FONT>      @Override<a name="line.834"></a>
<FONT color="green">835</FONT>      public boolean storeUser(User user, String xmlUser, String xmlUserRef) {<a name="line.835"></a>
<FONT color="green">836</FONT>        Connection conn = null;<a name="line.836"></a>
<FONT color="green">837</FONT>        PreparedStatement s = null;<a name="line.837"></a>
<FONT color="green">838</FONT>        try {<a name="line.838"></a>
<FONT color="green">839</FONT>          conn = DriverManager.getConnection(connectionURL);<a name="line.839"></a>
<FONT color="green">840</FONT>          s = conn.prepareStatement("INSERT INTO HackyUser VALUES (?, ?, ?, ?, ?, ?)");<a name="line.840"></a>
<FONT color="green">841</FONT>          // Order: Email Password Role XmlUser XmlUserRef LastMod<a name="line.841"></a>
<FONT color="green">842</FONT>          s.setString(1, user.getEmail());<a name="line.842"></a>
<FONT color="green">843</FONT>          s.setString(2, user.getPassword());<a name="line.843"></a>
<FONT color="green">844</FONT>          s.setString(3, user.getRole());<a name="line.844"></a>
<FONT color="green">845</FONT>          s.setString(4, xmlUser);<a name="line.845"></a>
<FONT color="green">846</FONT>          s.setString(5, xmlUserRef);<a name="line.846"></a>
<FONT color="green">847</FONT>          s.setTimestamp(6, new Timestamp(new Date().getTime()));<a name="line.847"></a>
<FONT color="green">848</FONT>          s.executeUpdate();<a name="line.848"></a>
<FONT color="green">849</FONT>          this.logger.fine("Derby: Inserted User" + user.getEmail());<a name="line.849"></a>
<FONT color="green">850</FONT>        }<a name="line.850"></a>
<FONT color="green">851</FONT>        catch (SQLException e) {<a name="line.851"></a>
<FONT color="green">852</FONT>          if (DUPLICATE_KEY.equals(e.getSQLState())) {<a name="line.852"></a>
<FONT color="green">853</FONT>            try {<a name="line.853"></a>
<FONT color="green">854</FONT>              // Do an update, not an insert.<a name="line.854"></a>
<FONT color="green">855</FONT>              s = conn.prepareStatement(<a name="line.855"></a>
<FONT color="green">856</FONT>                  "UPDATE HackyUser SET "<a name="line.856"></a>
<FONT color="green">857</FONT>                  + " Password=?, " <a name="line.857"></a>
<FONT color="green">858</FONT>                  + " Role=?, " <a name="line.858"></a>
<FONT color="green">859</FONT>                  + " XmlUser=?, " <a name="line.859"></a>
<FONT color="green">860</FONT>                  + " XmlUserRef=?, "<a name="line.860"></a>
<FONT color="green">861</FONT>                  + " LastMod=?"<a name="line.861"></a>
<FONT color="green">862</FONT>                  + " WHERE Email=?");<a name="line.862"></a>
<FONT color="green">863</FONT>              s.setString(1, user.getPassword());<a name="line.863"></a>
<FONT color="green">864</FONT>              s.setString(2, user.getRole());<a name="line.864"></a>
<FONT color="green">865</FONT>              s.setString(3, xmlUser);<a name="line.865"></a>
<FONT color="green">866</FONT>              s.setString(4, xmlUserRef);<a name="line.866"></a>
<FONT color="green">867</FONT>              s.setTimestamp(5, new Timestamp(new Date().getTime()));<a name="line.867"></a>
<FONT color="green">868</FONT>              s.setString(6, user.getEmail());<a name="line.868"></a>
<FONT color="green">869</FONT>              s.executeUpdate();<a name="line.869"></a>
<FONT color="green">870</FONT>              this.logger.fine("Derby: Updated User " + user.getEmail());<a name="line.870"></a>
<FONT color="green">871</FONT>            }<a name="line.871"></a>
<FONT color="green">872</FONT>            catch (SQLException f) {<a name="line.872"></a>
<FONT color="green">873</FONT>              this.logger.info(derbyError + StackTrace.toString(f));<a name="line.873"></a>
<FONT color="green">874</FONT>            }<a name="line.874"></a>
<FONT color="green">875</FONT>          }<a name="line.875"></a>
<FONT color="green">876</FONT>          else {<a name="line.876"></a>
<FONT color="green">877</FONT>            this.logger.info(derbyError + StackTrace.toString(e));<a name="line.877"></a>
<FONT color="green">878</FONT>          }<a name="line.878"></a>
<FONT color="green">879</FONT>        }<a name="line.879"></a>
<FONT color="green">880</FONT>        finally {<a name="line.880"></a>
<FONT color="green">881</FONT>          try {<a name="line.881"></a>
<FONT color="green">882</FONT>            s.close();<a name="line.882"></a>
<FONT color="green">883</FONT>            conn.close();<a name="line.883"></a>
<FONT color="green">884</FONT>          }<a name="line.884"></a>
<FONT color="green">885</FONT>          catch (SQLException e) {<a name="line.885"></a>
<FONT color="green">886</FONT>            this.logger.warning(errorClosingMsg + StackTrace.toString(e));<a name="line.886"></a>
<FONT color="green">887</FONT>          }<a name="line.887"></a>
<FONT color="green">888</FONT>        }<a name="line.888"></a>
<FONT color="green">889</FONT>        return true;<a name="line.889"></a>
<FONT color="green">890</FONT>      }<a name="line.890"></a>
<FONT color="green">891</FONT>    <a name="line.891"></a>
<FONT color="green">892</FONT>      // ********************   Start Project specific stuff here *****************  //<a name="line.892"></a>
<FONT color="green">893</FONT>    <a name="line.893"></a>
<FONT color="green">894</FONT>      /** The SQL string for creating the Project table.  */<a name="line.894"></a>
<FONT color="green">895</FONT>      private static final String createProjectTableStatement = <a name="line.895"></a>
<FONT color="green">896</FONT>        "create table Project  "<a name="line.896"></a>
<FONT color="green">897</FONT>        + "("<a name="line.897"></a>
<FONT color="green">898</FONT>        + " Owner VARCHAR(128) NOT NULL, "<a name="line.898"></a>
<FONT color="green">899</FONT>        + " ProjectName VARCHAR(128) NOT NULL, "<a name="line.899"></a>
<FONT color="green">900</FONT>        + " StartTime TIMESTAMP NOT NULL, "<a name="line.900"></a>
<FONT color="green">901</FONT>        + " EndTime TIMESTAMP NOT NULL, "<a name="line.901"></a>
<FONT color="green">902</FONT>        + " XmlProject VARCHAR(32000) NOT NULL, "<a name="line.902"></a>
<FONT color="green">903</FONT>        + " XmlProjectRef VARCHAR(1000) NOT NULL, "<a name="line.903"></a>
<FONT color="green">904</FONT>        + " LastMod TIMESTAMP NOT NULL, "<a name="line.904"></a>
<FONT color="green">905</FONT>        + " PRIMARY KEY (Owner, ProjectName) "<a name="line.905"></a>
<FONT color="green">906</FONT>        + ")" ;<a name="line.906"></a>
<FONT color="green">907</FONT>      <a name="line.907"></a>
<FONT color="green">908</FONT>      /** An SQL string to test whether the Project table exists and has the correct schema. */<a name="line.908"></a>
<FONT color="green">909</FONT>      private static final String testProjectTableStatement = <a name="line.909"></a>
<FONT color="green">910</FONT>        " UPDATE Project SET "<a name="line.910"></a>
<FONT color="green">911</FONT>        + " Owner = 'TestEmail@foo.com', " <a name="line.911"></a>
<FONT color="green">912</FONT>        + " ProjectName = 'TestProject', " <a name="line.912"></a>
<FONT color="green">913</FONT>        + " StartTime = '" + new Timestamp(new Date().getTime()).toString() + "', "<a name="line.913"></a>
<FONT color="green">914</FONT>        + " EndTime = '" + new Timestamp(new Date().getTime()).toString() + "', "<a name="line.914"></a>
<FONT color="green">915</FONT>        + " XmlProject = 'testXmlResource', "<a name="line.915"></a>
<FONT color="green">916</FONT>        + " XmlProjectRef = 'testXmlRef', "<a name="line.916"></a>
<FONT color="green">917</FONT>        + " LastMod = '" + new Timestamp(new Date().getTime()).toString() + "' "<a name="line.917"></a>
<FONT color="green">918</FONT>        + " WHERE 1=3";<a name="line.918"></a>
<FONT color="green">919</FONT>      <a name="line.919"></a>
<FONT color="green">920</FONT>      private static final String indexProjectNameStatement = <a name="line.920"></a>
<FONT color="green">921</FONT>        "CREATE INDEX ProjectNameIndex ON Project(ProjectName asc)";<a name="line.921"></a>
<FONT color="green">922</FONT>      private static final String dropIndexProjectNameStatement = <a name="line.922"></a>
<FONT color="green">923</FONT>        "DROP INDEX ProjectNameIndex";<a name="line.923"></a>
<FONT color="green">924</FONT>    <a name="line.924"></a>
<FONT color="green">925</FONT>      /** {@inheritDoc} */<a name="line.925"></a>
<FONT color="green">926</FONT>      @Override<a name="line.926"></a>
<FONT color="green">927</FONT>      public void deleteProject(User owner, String projectName) {<a name="line.927"></a>
<FONT color="green">928</FONT>        String statement =<a name="line.928"></a>
<FONT color="green">929</FONT>          "DELETE FROM Project WHERE "<a name="line.929"></a>
<FONT color="green">930</FONT>          + ownerEquals + owner.getEmail() + quoteAndClause <a name="line.930"></a>
<FONT color="green">931</FONT>          + " ProjectName = '" + projectName + "'";<a name="line.931"></a>
<FONT color="green">932</FONT>        deleteResource(statement);<a name="line.932"></a>
<FONT color="green">933</FONT>      }<a name="line.933"></a>
<FONT color="green">934</FONT>    <a name="line.934"></a>
<FONT color="green">935</FONT>      /** {@inheritDoc} */<a name="line.935"></a>
<FONT color="green">936</FONT>      @Override<a name="line.936"></a>
<FONT color="green">937</FONT>      public String getProject(User owner, String projectName) {<a name="line.937"></a>
<FONT color="green">938</FONT>        String statement =<a name="line.938"></a>
<FONT color="green">939</FONT>          "SELECT XmlProject FROM Project WHERE "<a name="line.939"></a>
<FONT color="green">940</FONT>          + ownerEquals + owner.getEmail() + quoteAndClause <a name="line.940"></a>
<FONT color="green">941</FONT>          + " ProjectName ='" + projectName + "'";<a name="line.941"></a>
<FONT color="green">942</FONT>        return getResource("Project", statement);<a name="line.942"></a>
<FONT color="green">943</FONT>      }<a name="line.943"></a>
<FONT color="green">944</FONT>    <a name="line.944"></a>
<FONT color="green">945</FONT>      /** {@inheritDoc} */<a name="line.945"></a>
<FONT color="green">946</FONT>      @Override<a name="line.946"></a>
<FONT color="green">947</FONT>      public String getProjectIndex() {<a name="line.947"></a>
<FONT color="green">948</FONT>        return getIndex("Project", "SELECT XmlProjectRef FROM Project ORDER BY ProjectName");<a name="line.948"></a>
<FONT color="green">949</FONT>      }<a name="line.949"></a>
<FONT color="green">950</FONT>      <a name="line.950"></a>
<FONT color="green">951</FONT>      /** {@inheritDoc} */<a name="line.951"></a>
<FONT color="green">952</FONT>      @Override  <a name="line.952"></a>
<FONT color="green">953</FONT>      public ProjectSummary getProjectSummary(List&lt;User&gt; users, XMLGregorianCalendar startTime, <a name="line.953"></a>
<FONT color="green">954</FONT>          XMLGregorianCalendar endTime, List&lt;String&gt; uriPatterns, String href) {<a name="line.954"></a>
<FONT color="green">955</FONT>        // Make a statement to return all SensorData for this project in the time period.<a name="line.955"></a>
<FONT color="green">956</FONT>        String statement = <a name="line.956"></a>
<FONT color="green">957</FONT>          "SELECT Sdt, Tool FROM SensorData WHERE "<a name="line.957"></a>
<FONT color="green">958</FONT>          + constructOwnerClause(users)<a name="line.958"></a>
<FONT color="green">959</FONT>          + andClause <a name="line.959"></a>
<FONT color="green">960</FONT>          + " (Tstamp BETWEEN TIMESTAMP('" + Tstamp.makeTimestamp(startTime) + "') AND "<a name="line.960"></a>
<FONT color="green">961</FONT>          + " TIMESTAMP('" + Tstamp.makeTimestamp(endTime) + "'))"<a name="line.961"></a>
<FONT color="green">962</FONT>          + constructLikeClauses(uriPatterns);<a name="line.962"></a>
<FONT color="green">963</FONT>        <a name="line.963"></a>
<FONT color="green">964</FONT>        // Create the [SDT, Tool] -&gt; NumInstances data structure.<a name="line.964"></a>
<FONT color="green">965</FONT>        Map&lt;String, Map&lt;String, Integer&gt;&gt; sdtInstances = new HashMap&lt;String, Map&lt;String, Integer&gt;&gt;();<a name="line.965"></a>
<FONT color="green">966</FONT>        <a name="line.966"></a>
<FONT color="green">967</FONT>        // Retrieve the sensordata for this project and time period.<a name="line.967"></a>
<FONT color="green">968</FONT>        Connection conn = null;<a name="line.968"></a>
<FONT color="green">969</FONT>        PreparedStatement s = null;<a name="line.969"></a>
<FONT color="green">970</FONT>        ResultSet rs = null;<a name="line.970"></a>
<FONT color="green">971</FONT>        try {<a name="line.971"></a>
<FONT color="green">972</FONT>          conn = DriverManager.getConnection(connectionURL);<a name="line.972"></a>
<FONT color="green">973</FONT>          s = conn.prepareStatement(statement);<a name="line.973"></a>
<FONT color="green">974</FONT>          rs = s.executeQuery();<a name="line.974"></a>
<FONT color="green">975</FONT>          // Loop through all retrieved SensorData records.<a name="line.975"></a>
<FONT color="green">976</FONT>          while (rs.next()) {<a name="line.976"></a>
<FONT color="green">977</FONT>            String sdt = rs.getString("Sdt");<a name="line.977"></a>
<FONT color="green">978</FONT>            String tool = rs.getString("Tool");<a name="line.978"></a>
<FONT color="green">979</FONT>            // Don't want null SDTs or Tools, call them the empty string instead.<a name="line.979"></a>
<FONT color="green">980</FONT>            if (sdt == null) {<a name="line.980"></a>
<FONT color="green">981</FONT>              sdt = "";<a name="line.981"></a>
<FONT color="green">982</FONT>            }<a name="line.982"></a>
<FONT color="green">983</FONT>            if (tool == null) {<a name="line.983"></a>
<FONT color="green">984</FONT>              tool = "";<a name="line.984"></a>
<FONT color="green">985</FONT>            }<a name="line.985"></a>
<FONT color="green">986</FONT>            // Now update our numInstance data structure.<a name="line.986"></a>
<FONT color="green">987</FONT>            // First, initialize the data structure if this is a new SDT.<a name="line.987"></a>
<FONT color="green">988</FONT>            if (!sdtInstances.containsKey(sdt)) {<a name="line.988"></a>
<FONT color="green">989</FONT>              Map&lt;String, Integer&gt; tool2NumInstances = new HashMap&lt;String, Integer&gt;();<a name="line.989"></a>
<FONT color="green">990</FONT>              tool2NumInstances.put(tool, 0);<a name="line.990"></a>
<FONT color="green">991</FONT>              sdtInstances.put(sdt, tool2NumInstances);<a name="line.991"></a>
<FONT color="green">992</FONT>            }<a name="line.992"></a>
<FONT color="green">993</FONT>            Map&lt;String, Integer&gt; tool2NumInstances = sdtInstances.get(sdt);<a name="line.993"></a>
<FONT color="green">994</FONT>            // Second, initialize the data structure if this is a new tool for a preexisting SDT.<a name="line.994"></a>
<FONT color="green">995</FONT>            if (tool2NumInstances.get(tool) == null) {<a name="line.995"></a>
<FONT color="green">996</FONT>              tool2NumInstances.put(tool, 0);<a name="line.996"></a>
<FONT color="green">997</FONT>            }<a name="line.997"></a>
<FONT color="green">998</FONT>            // Finally, increment this entry.<a name="line.998"></a>
<FONT color="green">999</FONT>            tool2NumInstances.put(tool, tool2NumInstances.get(tool) + 1);<a name="line.999"></a>
<FONT color="green">1000</FONT>          }<a name="line.1000"></a>
<FONT color="green">1001</FONT>        }<a name="line.1001"></a>
<FONT color="green">1002</FONT>        catch (SQLException e) {<a name="line.1002"></a>
<FONT color="green">1003</FONT>          this.logger.info("Derby: Error in getProjectSummary()" + StackTrace.toString(e));<a name="line.1003"></a>
<FONT color="green">1004</FONT>        }<a name="line.1004"></a>
<FONT color="green">1005</FONT>        finally {<a name="line.1005"></a>
<FONT color="green">1006</FONT>          try {<a name="line.1006"></a>
<FONT color="green">1007</FONT>            rs.close();<a name="line.1007"></a>
<FONT color="green">1008</FONT>            s.close();<a name="line.1008"></a>
<FONT color="green">1009</FONT>            conn.close();<a name="line.1009"></a>
<FONT color="green">1010</FONT>          }<a name="line.1010"></a>
<FONT color="green">1011</FONT>          catch (SQLException e) {<a name="line.1011"></a>
<FONT color="green">1012</FONT>            this.logger.warning(errorClosingMsg + StackTrace.toString(e));<a name="line.1012"></a>
<FONT color="green">1013</FONT>          }<a name="line.1013"></a>
<FONT color="green">1014</FONT>        }<a name="line.1014"></a>
<FONT color="green">1015</FONT>        <a name="line.1015"></a>
<FONT color="green">1016</FONT>        //Now create the project summary object from our data structures.<a name="line.1016"></a>
<FONT color="green">1017</FONT>        return makeProjectSummary(href, startTime, endTime, sdtInstances);<a name="line.1017"></a>
<FONT color="green">1018</FONT>      }<a name="line.1018"></a>
<FONT color="green">1019</FONT>    <a name="line.1019"></a>
<FONT color="green">1020</FONT>      /**<a name="line.1020"></a>
<FONT color="green">1021</FONT>       * Creates a ProjectSummary instances from the passed data. <a name="line.1021"></a>
<FONT color="green">1022</FONT>       * @param href  The Href representing this resource.<a name="line.1022"></a>
<FONT color="green">1023</FONT>       * @param startTime The startTime for this data.<a name="line.1023"></a>
<FONT color="green">1024</FONT>       * @param endTime The endTime for this data.<a name="line.1024"></a>
<FONT color="green">1025</FONT>       * @param sdtInstances The data structure containing the instances. <a name="line.1025"></a>
<FONT color="green">1026</FONT>       * @return The ProjectSummary instance. <a name="line.1026"></a>
<FONT color="green">1027</FONT>       */<a name="line.1027"></a>
<FONT color="green">1028</FONT>      private ProjectSummary makeProjectSummary(String href, XMLGregorianCalendar startTime, <a name="line.1028"></a>
<FONT color="green">1029</FONT>          XMLGregorianCalendar endTime, Map&lt;String, Map&lt;String, Integer&gt;&gt; sdtInstances) {<a name="line.1029"></a>
<FONT color="green">1030</FONT>        ProjectSummary projectSummary = new ProjectSummary();<a name="line.1030"></a>
<FONT color="green">1031</FONT>        projectSummary.setHref(href);<a name="line.1031"></a>
<FONT color="green">1032</FONT>        projectSummary.setStartTime(startTime);<a name="line.1032"></a>
<FONT color="green">1033</FONT>        projectSummary.setEndTime(endTime);<a name="line.1033"></a>
<FONT color="green">1034</FONT>        projectSummary.setLastMod(Tstamp.makeTimestamp());<a name="line.1034"></a>
<FONT color="green">1035</FONT>        SensorDataSummaries summaries = new SensorDataSummaries();<a name="line.1035"></a>
<FONT color="green">1036</FONT>        projectSummary.setSensorDataSummaries(summaries);<a name="line.1036"></a>
<FONT color="green">1037</FONT>        int totalInstances = 0;<a name="line.1037"></a>
<FONT color="green">1038</FONT>        for (Map.Entry&lt;String, Map&lt;String, Integer&gt;&gt; entry : sdtInstances.entrySet()) {<a name="line.1038"></a>
<FONT color="green">1039</FONT>          String sdt = entry.getKey();<a name="line.1039"></a>
<FONT color="green">1040</FONT>          Map&lt;String, Integer&gt; tool2NumInstances = entry.getValue();<a name="line.1040"></a>
<FONT color="green">1041</FONT>          for (Map.Entry&lt;String, Integer&gt; entry2 : tool2NumInstances.entrySet()) {<a name="line.1041"></a>
<FONT color="green">1042</FONT>            SensorDataSummary summary = new SensorDataSummary();<a name="line.1042"></a>
<FONT color="green">1043</FONT>            summary.setSensorDataType(sdt);<a name="line.1043"></a>
<FONT color="green">1044</FONT>            summary.setTool(entry2.getKey());<a name="line.1044"></a>
<FONT color="green">1045</FONT>            int numInstances = entry2.getValue();<a name="line.1045"></a>
<FONT color="green">1046</FONT>            totalInstances += numInstances;<a name="line.1046"></a>
<FONT color="green">1047</FONT>            summary.setNumInstances(BigInteger.valueOf(numInstances));<a name="line.1047"></a>
<FONT color="green">1048</FONT>            summaries.getSensorDataSummary().add(summary);<a name="line.1048"></a>
<FONT color="green">1049</FONT>          }<a name="line.1049"></a>
<FONT color="green">1050</FONT>        }<a name="line.1050"></a>
<FONT color="green">1051</FONT>        summaries.setNumInstances(BigInteger.valueOf(totalInstances));<a name="line.1051"></a>
<FONT color="green">1052</FONT>        return projectSummary;<a name="line.1052"></a>
<FONT color="green">1053</FONT>      }<a name="line.1053"></a>
<FONT color="green">1054</FONT>      <a name="line.1054"></a>
<FONT color="green">1055</FONT>    <a name="line.1055"></a>
<FONT color="green">1056</FONT>      /** {@inheritDoc} */<a name="line.1056"></a>
<FONT color="green">1057</FONT>      @Override<a name="line.1057"></a>
<FONT color="green">1058</FONT>      public boolean storeProject(Project project, String xmlProject, String xmlProjectRef) {<a name="line.1058"></a>
<FONT color="green">1059</FONT>        Connection conn = null;<a name="line.1059"></a>
<FONT color="green">1060</FONT>        PreparedStatement s = null;<a name="line.1060"></a>
<FONT color="green">1061</FONT>        try {<a name="line.1061"></a>
<FONT color="green">1062</FONT>          conn = DriverManager.getConnection(connectionURL);<a name="line.1062"></a>
<FONT color="green">1063</FONT>          s = conn.prepareStatement("INSERT INTO Project VALUES (?, ?, ?, ?, ?, ?, ?)");<a name="line.1063"></a>
<FONT color="green">1064</FONT>          // Order: Owner ProjectName StartTime EndTime XmlProject XmlProjectRef LastMod<a name="line.1064"></a>
<FONT color="green">1065</FONT>          s.setString(1, project.getOwner());<a name="line.1065"></a>
<FONT color="green">1066</FONT>          s.setString(2, project.getName());<a name="line.1066"></a>
<FONT color="green">1067</FONT>          s.setTimestamp(3, Tstamp.makeTimestamp(project.getStartTime()));<a name="line.1067"></a>
<FONT color="green">1068</FONT>          s.setTimestamp(4, Tstamp.makeTimestamp(project.getEndTime()));<a name="line.1068"></a>
<FONT color="green">1069</FONT>          s.setString(5, xmlProject);<a name="line.1069"></a>
<FONT color="green">1070</FONT>          s.setString(6, xmlProjectRef);<a name="line.1070"></a>
<FONT color="green">1071</FONT>          s.setTimestamp(7, Tstamp.makeTimestamp(project.getLastMod()));<a name="line.1071"></a>
<FONT color="green">1072</FONT>          s.executeUpdate();<a name="line.1072"></a>
<FONT color="green">1073</FONT>          this.logger.fine("Derby: Inserted " + project.getOwner() + " " + project.getName());<a name="line.1073"></a>
<FONT color="green">1074</FONT>        }<a name="line.1074"></a>
<FONT color="green">1075</FONT>        catch (SQLException e) {<a name="line.1075"></a>
<FONT color="green">1076</FONT>          if (DUPLICATE_KEY.equals(e.getSQLState())) {<a name="line.1076"></a>
<FONT color="green">1077</FONT>            try {<a name="line.1077"></a>
<FONT color="green">1078</FONT>              // Do an update, not an insert.<a name="line.1078"></a>
<FONT color="green">1079</FONT>              s = conn.prepareStatement(<a name="line.1079"></a>
<FONT color="green">1080</FONT>                  "UPDATE Project SET "<a name="line.1080"></a>
<FONT color="green">1081</FONT>                  + " StartTime=?, EndTime=?, XmlProject=?, " <a name="line.1081"></a>
<FONT color="green">1082</FONT>                  + " XmlProjectRef=?, LastMod=?"<a name="line.1082"></a>
<FONT color="green">1083</FONT>                  + " WHERE Owner=? AND ProjectName=?");<a name="line.1083"></a>
<FONT color="green">1084</FONT>              s.setTimestamp(1, Tstamp.makeTimestamp(project.getStartTime()));<a name="line.1084"></a>
<FONT color="green">1085</FONT>              s.setTimestamp(2, Tstamp.makeTimestamp(project.getEndTime()));<a name="line.1085"></a>
<FONT color="green">1086</FONT>              s.setString(3, xmlProject);<a name="line.1086"></a>
<FONT color="green">1087</FONT>              s.setString(4, xmlProjectRef);<a name="line.1087"></a>
<FONT color="green">1088</FONT>              s.setTimestamp(5, Tstamp.makeTimestamp(project.getEndTime()));<a name="line.1088"></a>
<FONT color="green">1089</FONT>              s.setString(6, project.getOwner());<a name="line.1089"></a>
<FONT color="green">1090</FONT>              s.setString(7, project.getName());<a name="line.1090"></a>
<FONT color="green">1091</FONT>              s.executeUpdate();<a name="line.1091"></a>
<FONT color="green">1092</FONT>              this.logger.fine("Derby: Updated " + project.getOwner() + " " + project.getName());<a name="line.1092"></a>
<FONT color="green">1093</FONT>            }<a name="line.1093"></a>
<FONT color="green">1094</FONT>            catch (SQLException f) {<a name="line.1094"></a>
<FONT color="green">1095</FONT>              this.logger.info(derbyError + StackTrace.toString(f));<a name="line.1095"></a>
<FONT color="green">1096</FONT>            }<a name="line.1096"></a>
<FONT color="green">1097</FONT>          }<a name="line.1097"></a>
<FONT color="green">1098</FONT>        }<a name="line.1098"></a>
<FONT color="green">1099</FONT>        finally {<a name="line.1099"></a>
<FONT color="green">1100</FONT>          try {<a name="line.1100"></a>
<FONT color="green">1101</FONT>            s.close();<a name="line.1101"></a>
<FONT color="green">1102</FONT>            conn.close();<a name="line.1102"></a>
<FONT color="green">1103</FONT>          }<a name="line.1103"></a>
<FONT color="green">1104</FONT>          catch (SQLException e) {<a name="line.1104"></a>
<FONT color="green">1105</FONT>            this.logger.warning(errorClosingMsg + StackTrace.toString(e));<a name="line.1105"></a>
<FONT color="green">1106</FONT>          }<a name="line.1106"></a>
<FONT color="green">1107</FONT>        }<a name="line.1107"></a>
<FONT color="green">1108</FONT>        return true;<a name="line.1108"></a>
<FONT color="green">1109</FONT>      }<a name="line.1109"></a>
<FONT color="green">1110</FONT>      <a name="line.1110"></a>
<FONT color="green">1111</FONT>      // **************************** Internal helper functions *****************************<a name="line.1111"></a>
<FONT color="green">1112</FONT>      <a name="line.1112"></a>
<FONT color="green">1113</FONT>      /**<a name="line.1113"></a>
<FONT color="green">1114</FONT>       * Returns a string containing the Index for the given resource indicated by resourceName.<a name="line.1114"></a>
<FONT color="green">1115</FONT>       * @param resourceName The resource name, such as "Project". <a name="line.1115"></a>
<FONT color="green">1116</FONT>       * @param statement The SQL Statement to be used to retrieve the resource references.<a name="line.1116"></a>
<FONT color="green">1117</FONT>       * @return The aggregate Index XML string. <a name="line.1117"></a>
<FONT color="green">1118</FONT>       */<a name="line.1118"></a>
<FONT color="green">1119</FONT>      private String getIndex(String resourceName, String statement) {<a name="line.1119"></a>
<FONT color="green">1120</FONT>        StringBuilder builder = new StringBuilder(512);<a name="line.1120"></a>
<FONT color="green">1121</FONT>        builder.append("&lt;").append(resourceName).append(indexSuffix);<a name="line.1121"></a>
<FONT color="green">1122</FONT>        // Retrieve all the SensorData<a name="line.1122"></a>
<FONT color="green">1123</FONT>        Connection conn = null;<a name="line.1123"></a>
<FONT color="green">1124</FONT>        PreparedStatement s = null;<a name="line.1124"></a>
<FONT color="green">1125</FONT>        ResultSet rs = null;<a name="line.1125"></a>
<FONT color="green">1126</FONT>        try {<a name="line.1126"></a>
<FONT color="green">1127</FONT>          conn = DriverManager.getConnection(connectionURL);<a name="line.1127"></a>
<FONT color="green">1128</FONT>          s = conn.prepareStatement(statement);<a name="line.1128"></a>
<FONT color="green">1129</FONT>          rs = s.executeQuery();<a name="line.1129"></a>
<FONT color="green">1130</FONT>          String resourceRefColumnName = xml + resourceName + "Ref";<a name="line.1130"></a>
<FONT color="green">1131</FONT>          while (rs.next()) {<a name="line.1131"></a>
<FONT color="green">1132</FONT>            builder.append(rs.getString(resourceRefColumnName));<a name="line.1132"></a>
<FONT color="green">1133</FONT>          }<a name="line.1133"></a>
<FONT color="green">1134</FONT>        }<a name="line.1134"></a>
<FONT color="green">1135</FONT>        catch (SQLException e) {<a name="line.1135"></a>
<FONT color="green">1136</FONT>          this.logger.info("Derby: Error in getIndex()" + StackTrace.toString(e));<a name="line.1136"></a>
<FONT color="green">1137</FONT>        }<a name="line.1137"></a>
<FONT color="green">1138</FONT>        finally {<a name="line.1138"></a>
<FONT color="green">1139</FONT>          try {<a name="line.1139"></a>
<FONT color="green">1140</FONT>            rs.close();<a name="line.1140"></a>
<FONT color="green">1141</FONT>            s.close();<a name="line.1141"></a>
<FONT color="green">1142</FONT>            conn.close();<a name="line.1142"></a>
<FONT color="green">1143</FONT>          }<a name="line.1143"></a>
<FONT color="green">1144</FONT>          catch (SQLException e) {<a name="line.1144"></a>
<FONT color="green">1145</FONT>            this.logger.warning(errorClosingMsg + StackTrace.toString(e));<a name="line.1145"></a>
<FONT color="green">1146</FONT>          }<a name="line.1146"></a>
<FONT color="green">1147</FONT>        }<a name="line.1147"></a>
<FONT color="green">1148</FONT>        builder.append("&lt;/").append(resourceName).append(indexSuffix);<a name="line.1148"></a>
<FONT color="green">1149</FONT>        //System.out.println(builder.toString());<a name="line.1149"></a>
<FONT color="green">1150</FONT>        return builder.toString();<a name="line.1150"></a>
<FONT color="green">1151</FONT>      }<a name="line.1151"></a>
<FONT color="green">1152</FONT>      <a name="line.1152"></a>
<FONT color="green">1153</FONT>      /**<a name="line.1153"></a>
<FONT color="green">1154</FONT>       * Returns a string containing the Index of all of the SensorData whose runtime field matches<a name="line.1154"></a>
<FONT color="green">1155</FONT>       * the first runtime in the result set.  Since the passed statement will retrieve sensor<a name="line.1155"></a>
<FONT color="green">1156</FONT>       * data in the given time period ordered in descending order by runtime, this should result<a name="line.1156"></a>
<FONT color="green">1157</FONT>       * in an index containing only  <a name="line.1157"></a>
<FONT color="green">1158</FONT>       * @param statement The SQL Statement to be used to retrieve the resource references.<a name="line.1158"></a>
<FONT color="green">1159</FONT>       * @return The aggregate Index XML string. <a name="line.1159"></a>
<FONT color="green">1160</FONT>       */<a name="line.1160"></a>
<FONT color="green">1161</FONT>      private String getSnapshotIndex(String statement) {<a name="line.1161"></a>
<FONT color="green">1162</FONT>        String resourceName = "SensorData";<a name="line.1162"></a>
<FONT color="green">1163</FONT>        StringBuilder builder = new StringBuilder(512);<a name="line.1163"></a>
<FONT color="green">1164</FONT>        builder.append("&lt;").append(resourceName).append(indexSuffix);<a name="line.1164"></a>
<FONT color="green">1165</FONT>        // Retrieve all the SensorData<a name="line.1165"></a>
<FONT color="green">1166</FONT>        Connection conn = null;<a name="line.1166"></a>
<FONT color="green">1167</FONT>        PreparedStatement s = null;<a name="line.1167"></a>
<FONT color="green">1168</FONT>        ResultSet rs = null;<a name="line.1168"></a>
<FONT color="green">1169</FONT>        String firstRunTime = null;<a name="line.1169"></a>
<FONT color="green">1170</FONT>        try {<a name="line.1170"></a>
<FONT color="green">1171</FONT>          conn = DriverManager.getConnection(connectionURL);<a name="line.1171"></a>
<FONT color="green">1172</FONT>          s = conn.prepareStatement(statement);<a name="line.1172"></a>
<FONT color="green">1173</FONT>          rs = s.executeQuery();<a name="line.1173"></a>
<FONT color="green">1174</FONT>          String resourceRefColumnName = xml + resourceName + "Ref";<a name="line.1174"></a>
<FONT color="green">1175</FONT>          boolean finished = false;<a name="line.1175"></a>
<FONT color="green">1176</FONT>          // Add all entries with the first retrieved nruntime value to the index.<a name="line.1176"></a>
<FONT color="green">1177</FONT>          while (rs.next() &amp;&amp; !finished) {<a name="line.1177"></a>
<FONT color="green">1178</FONT>            String runtime = rs.getString("Runtime");<a name="line.1178"></a>
<FONT color="green">1179</FONT>            // Should never be null, but just in case. <a name="line.1179"></a>
<FONT color="green">1180</FONT>            if (runtime != null) {<a name="line.1180"></a>
<FONT color="green">1181</FONT>              // Initial firstRunTime to the first retrieved non-null runtime value.<a name="line.1181"></a>
<FONT color="green">1182</FONT>              if (firstRunTime == null) {<a name="line.1182"></a>
<FONT color="green">1183</FONT>                firstRunTime = runtime;<a name="line.1183"></a>
<FONT color="green">1184</FONT>              }<a name="line.1184"></a>
<FONT color="green">1185</FONT>              // Now add every entry whose runtime equals the first retrieved run time.<a name="line.1185"></a>
<FONT color="green">1186</FONT>              if (runtime.equals(firstRunTime)) {<a name="line.1186"></a>
<FONT color="green">1187</FONT>                builder.append(rs.getString(resourceRefColumnName));<a name="line.1187"></a>
<FONT color="green">1188</FONT>              }<a name="line.1188"></a>
<FONT color="green">1189</FONT>              else {<a name="line.1189"></a>
<FONT color="green">1190</FONT>                // As soon as we find a runtime not equal to firstRunTime, we can stop.<a name="line.1190"></a>
<FONT color="green">1191</FONT>                finished = true;<a name="line.1191"></a>
<FONT color="green">1192</FONT>              }<a name="line.1192"></a>
<FONT color="green">1193</FONT>            }<a name="line.1193"></a>
<FONT color="green">1194</FONT>          }<a name="line.1194"></a>
<FONT color="green">1195</FONT>        }<a name="line.1195"></a>
<FONT color="green">1196</FONT>        catch (SQLException e) {<a name="line.1196"></a>
<FONT color="green">1197</FONT>          this.logger.info("Derby: Error in getIndex()" + StackTrace.toString(e));<a name="line.1197"></a>
<FONT color="green">1198</FONT>        }<a name="line.1198"></a>
<FONT color="green">1199</FONT>        finally {<a name="line.1199"></a>
<FONT color="green">1200</FONT>          try {<a name="line.1200"></a>
<FONT color="green">1201</FONT>            rs.close();<a name="line.1201"></a>
<FONT color="green">1202</FONT>            s.close();<a name="line.1202"></a>
<FONT color="green">1203</FONT>            conn.close();<a name="line.1203"></a>
<FONT color="green">1204</FONT>          }<a name="line.1204"></a>
<FONT color="green">1205</FONT>          catch (SQLException e) {<a name="line.1205"></a>
<FONT color="green">1206</FONT>            this.logger.warning(errorClosingMsg + StackTrace.toString(e));<a name="line.1206"></a>
<FONT color="green">1207</FONT>          }<a name="line.1207"></a>
<FONT color="green">1208</FONT>        }<a name="line.1208"></a>
<FONT color="green">1209</FONT>        builder.append("&lt;/").append(resourceName).append(indexSuffix);<a name="line.1209"></a>
<FONT color="green">1210</FONT>        //System.out.println(builder.toString());<a name="line.1210"></a>
<FONT color="green">1211</FONT>        return builder.toString();<a name="line.1211"></a>
<FONT color="green">1212</FONT>      }<a name="line.1212"></a>
<FONT color="green">1213</FONT>      <a name="line.1213"></a>
<FONT color="green">1214</FONT>      /**<a name="line.1214"></a>
<FONT color="green">1215</FONT>       * Returns a string containing the Index for the given resource indicated by resourceName, <a name="line.1215"></a>
<FONT color="green">1216</FONT>       * returning only the instances starting at startIndex, and with the maximum number of<a name="line.1216"></a>
<FONT color="green">1217</FONT>       * returned instances indicated by maxInstances.   <a name="line.1217"></a>
<FONT color="green">1218</FONT>       * @param resourceName The resource name, such as "Project".<a name="line.1218"></a>
<FONT color="green">1219</FONT>       * @param startIndex The (zero-based) starting index for instances to be returned.<a name="line.1219"></a>
<FONT color="green">1220</FONT>       * @param maxInstances The maximum number of instances to return.  <a name="line.1220"></a>
<FONT color="green">1221</FONT>       * @param statement The SQL Statement to be used to retrieve the resource references.<a name="line.1221"></a>
<FONT color="green">1222</FONT>       * @return The aggregate Index XML string. <a name="line.1222"></a>
<FONT color="green">1223</FONT>       */<a name="line.1223"></a>
<FONT color="green">1224</FONT>      private String getIndex(String resourceName, String statement, int startIndex, int maxInstances) {<a name="line.1224"></a>
<FONT color="green">1225</FONT>        StringBuilder builder = new StringBuilder(512);<a name="line.1225"></a>
<FONT color="green">1226</FONT>        builder.append("&lt;").append(resourceName).append(indexSuffix);<a name="line.1226"></a>
<FONT color="green">1227</FONT>        // Retrieve all the SensorData to start.<a name="line.1227"></a>
<FONT color="green">1228</FONT>        Connection conn = null;<a name="line.1228"></a>
<FONT color="green">1229</FONT>        PreparedStatement s = null;<a name="line.1229"></a>
<FONT color="green">1230</FONT>        ResultSet rs = null;<a name="line.1230"></a>
<FONT color="green">1231</FONT>        try {<a name="line.1231"></a>
<FONT color="green">1232</FONT>          conn = DriverManager.getConnection(connectionURL);<a name="line.1232"></a>
<FONT color="green">1233</FONT>          s = conn.prepareStatement(statement);<a name="line.1233"></a>
<FONT color="green">1234</FONT>          rs = s.executeQuery();<a name="line.1234"></a>
<FONT color="green">1235</FONT>          int currIndex = 0;<a name="line.1235"></a>
<FONT color="green">1236</FONT>          int totalInstances = 0;<a name="line.1236"></a>
<FONT color="green">1237</FONT>          String resourceRefColumnName = xml + resourceName + "Ref";<a name="line.1237"></a>
<FONT color="green">1238</FONT>          while (rs.next()) {<a name="line.1238"></a>
<FONT color="green">1239</FONT>            if ((currIndex &gt;= startIndex) &amp;&amp; (totalInstances &lt; maxInstances)) {<a name="line.1239"></a>
<FONT color="green">1240</FONT>              builder.append(rs.getString(resourceRefColumnName));<a name="line.1240"></a>
<FONT color="green">1241</FONT>              totalInstances++;<a name="line.1241"></a>
<FONT color="green">1242</FONT>            }<a name="line.1242"></a>
<FONT color="green">1243</FONT>            currIndex++;<a name="line.1243"></a>
<FONT color="green">1244</FONT>          }<a name="line.1244"></a>
<FONT color="green">1245</FONT>        }<a name="line.1245"></a>
<FONT color="green">1246</FONT>        catch (SQLException e) {<a name="line.1246"></a>
<FONT color="green">1247</FONT>          this.logger.info("Derby: Error in getIndex()" + StackTrace.toString(e));<a name="line.1247"></a>
<FONT color="green">1248</FONT>        }<a name="line.1248"></a>
<FONT color="green">1249</FONT>        finally {<a name="line.1249"></a>
<FONT color="green">1250</FONT>          try {<a name="line.1250"></a>
<FONT color="green">1251</FONT>            rs.close();<a name="line.1251"></a>
<FONT color="green">1252</FONT>            s.close();<a name="line.1252"></a>
<FONT color="green">1253</FONT>            conn.close();<a name="line.1253"></a>
<FONT color="green">1254</FONT>          }<a name="line.1254"></a>
<FONT color="green">1255</FONT>          catch (SQLException e) {<a name="line.1255"></a>
<FONT color="green">1256</FONT>            this.logger.warning(errorClosingMsg + StackTrace.toString(e));<a name="line.1256"></a>
<FONT color="green">1257</FONT>          }<a name="line.1257"></a>
<FONT color="green">1258</FONT>        }<a name="line.1258"></a>
<FONT color="green">1259</FONT>        builder.append("&lt;/").append(resourceName).append(indexSuffix);<a name="line.1259"></a>
<FONT color="green">1260</FONT>        //System.out.println(builder.toString());<a name="line.1260"></a>
<FONT color="green">1261</FONT>        return builder.toString();<a name="line.1261"></a>
<FONT color="green">1262</FONT>      }<a name="line.1262"></a>
<FONT color="green">1263</FONT>      <a name="line.1263"></a>
<FONT color="green">1264</FONT>      /**<a name="line.1264"></a>
<FONT color="green">1265</FONT>       * Returns a string containing the Resource as XML, or null if not found.<a name="line.1265"></a>
<FONT color="green">1266</FONT>       * @param resourceName The name of the resource, such as "User".<a name="line.1266"></a>
<FONT color="green">1267</FONT>       * @param statement The select statement used to retrieve the resultset containing a single<a name="line.1267"></a>
<FONT color="green">1268</FONT>       * row with that resource.<a name="line.1268"></a>
<FONT color="green">1269</FONT>       * @return The string containing the resource as an XML string.<a name="line.1269"></a>
<FONT color="green">1270</FONT>       */<a name="line.1270"></a>
<FONT color="green">1271</FONT>      private String getResource(String resourceName, String statement) {<a name="line.1271"></a>
<FONT color="green">1272</FONT>        StringBuilder builder = new StringBuilder(512);<a name="line.1272"></a>
<FONT color="green">1273</FONT>        Connection conn = null;<a name="line.1273"></a>
<FONT color="green">1274</FONT>        PreparedStatement s = null;<a name="line.1274"></a>
<FONT color="green">1275</FONT>        ResultSet rs = null;<a name="line.1275"></a>
<FONT color="green">1276</FONT>        boolean hasData = false;<a name="line.1276"></a>
<FONT color="green">1277</FONT>        try {<a name="line.1277"></a>
<FONT color="green">1278</FONT>          conn = DriverManager.getConnection(connectionURL);<a name="line.1278"></a>
<FONT color="green">1279</FONT>          server.getLogger().fine(executeQueryMsg + statement);<a name="line.1279"></a>
<FONT color="green">1280</FONT>          s = conn.prepareStatement(statement);<a name="line.1280"></a>
<FONT color="green">1281</FONT>          rs = s.executeQuery();<a name="line.1281"></a>
<FONT color="green">1282</FONT>          String resourceXmlColumnName = xml + resourceName;<a name="line.1282"></a>
<FONT color="green">1283</FONT>          while (rs.next()) { // the select statement must guarantee only one row is returned.<a name="line.1283"></a>
<FONT color="green">1284</FONT>            hasData = true;<a name="line.1284"></a>
<FONT color="green">1285</FONT>            builder.append(rs.getString(resourceXmlColumnName));<a name="line.1285"></a>
<FONT color="green">1286</FONT>          }<a name="line.1286"></a>
<FONT color="green">1287</FONT>        }<a name="line.1287"></a>
<FONT color="green">1288</FONT>        catch (SQLException e) {<a name="line.1288"></a>
<FONT color="green">1289</FONT>          this.logger.info("DB: Error in getResource()" + StackTrace.toString(e));<a name="line.1289"></a>
<FONT color="green">1290</FONT>        }<a name="line.1290"></a>
<FONT color="green">1291</FONT>        finally {<a name="line.1291"></a>
<FONT color="green">1292</FONT>          try {<a name="line.1292"></a>
<FONT color="green">1293</FONT>            rs.close();<a name="line.1293"></a>
<FONT color="green">1294</FONT>            s.close();<a name="line.1294"></a>
<FONT color="green">1295</FONT>            conn.close();<a name="line.1295"></a>
<FONT color="green">1296</FONT>          }<a name="line.1296"></a>
<FONT color="green">1297</FONT>          catch (SQLException e) {<a name="line.1297"></a>
<FONT color="green">1298</FONT>            this.logger.warning(errorClosingMsg + StackTrace.toString(e));<a name="line.1298"></a>
<FONT color="green">1299</FONT>          }<a name="line.1299"></a>
<FONT color="green">1300</FONT>        }<a name="line.1300"></a>
<FONT color="green">1301</FONT>        return (hasData) ? builder.toString() : null;<a name="line.1301"></a>
<FONT color="green">1302</FONT>      }<a name="line.1302"></a>
<FONT color="green">1303</FONT>      <a name="line.1303"></a>
<FONT color="green">1304</FONT>      /**<a name="line.1304"></a>
<FONT color="green">1305</FONT>       * Deletes the resource, given the SQL statement to perform the delete.<a name="line.1305"></a>
<FONT color="green">1306</FONT>       * @param statement The SQL delete statement. <a name="line.1306"></a>
<FONT color="green">1307</FONT>       */<a name="line.1307"></a>
<FONT color="green">1308</FONT>      private void deleteResource(String statement) {<a name="line.1308"></a>
<FONT color="green">1309</FONT>        Connection conn = null;<a name="line.1309"></a>
<FONT color="green">1310</FONT>        PreparedStatement s = null;<a name="line.1310"></a>
<FONT color="green">1311</FONT>        try {<a name="line.1311"></a>
<FONT color="green">1312</FONT>          conn = DriverManager.getConnection(connectionURL);<a name="line.1312"></a>
<FONT color="green">1313</FONT>          server.getLogger().fine("Derby: " + statement);<a name="line.1313"></a>
<FONT color="green">1314</FONT>          s = conn.prepareStatement(statement);<a name="line.1314"></a>
<FONT color="green">1315</FONT>          s.executeUpdate();<a name="line.1315"></a>
<FONT color="green">1316</FONT>        }<a name="line.1316"></a>
<FONT color="green">1317</FONT>        catch (SQLException e) {<a name="line.1317"></a>
<FONT color="green">1318</FONT>          this.logger.info("Derby: Error in deleteResource()" + StackTrace.toString(e));<a name="line.1318"></a>
<FONT color="green">1319</FONT>        }<a name="line.1319"></a>
<FONT color="green">1320</FONT>        finally {<a name="line.1320"></a>
<FONT color="green">1321</FONT>          try {<a name="line.1321"></a>
<FONT color="green">1322</FONT>            s.close();<a name="line.1322"></a>
<FONT color="green">1323</FONT>            conn.close();<a name="line.1323"></a>
<FONT color="green">1324</FONT>          }<a name="line.1324"></a>
<FONT color="green">1325</FONT>          catch (SQLException e) {<a name="line.1325"></a>
<FONT color="green">1326</FONT>            this.logger.warning(errorClosingMsg + StackTrace.toString(e));<a name="line.1326"></a>
<FONT color="green">1327</FONT>          }<a name="line.1327"></a>
<FONT color="green">1328</FONT>        }<a name="line.1328"></a>
<FONT color="green">1329</FONT>      }<a name="line.1329"></a>
<FONT color="green">1330</FONT>    <a name="line.1330"></a>
<FONT color="green">1331</FONT>      <a name="line.1331"></a>
<FONT color="green">1332</FONT>      /** {@inheritDoc} */<a name="line.1332"></a>
<FONT color="green">1333</FONT>      @Override<a name="line.1333"></a>
<FONT color="green">1334</FONT>      public boolean compressTables() {<a name="line.1334"></a>
<FONT color="green">1335</FONT>        boolean success = false;<a name="line.1335"></a>
<FONT color="green">1336</FONT>        this.logger.fine("Starting to compress tables.");<a name="line.1336"></a>
<FONT color="green">1337</FONT>        Connection conn = null;<a name="line.1337"></a>
<FONT color="green">1338</FONT>        CallableStatement cs = null;<a name="line.1338"></a>
<FONT color="green">1339</FONT>        try {<a name="line.1339"></a>
<FONT color="green">1340</FONT>          conn = DriverManager.getConnection(connectionURL);<a name="line.1340"></a>
<FONT color="green">1341</FONT>          cs = conn.prepareCall("CALL SYSCS_UTIL.SYSCS_COMPRESS_TABLE(?, ?, ?)");<a name="line.1341"></a>
<FONT color="green">1342</FONT>          cs.setString(1, "APP");<a name="line.1342"></a>
<FONT color="green">1343</FONT>          cs.setString(2, "SENSORDATA");<a name="line.1343"></a>
<FONT color="green">1344</FONT>          cs.setShort(3, (short) 1);<a name="line.1344"></a>
<FONT color="green">1345</FONT>          cs.execute();<a name="line.1345"></a>
<FONT color="green">1346</FONT>          cs.setString(2, "SENSORDATATYPE");<a name="line.1346"></a>
<FONT color="green">1347</FONT>          cs.execute();<a name="line.1347"></a>
<FONT color="green">1348</FONT>          cs.setString(2, "HACKYUSER");<a name="line.1348"></a>
<FONT color="green">1349</FONT>          cs.execute();<a name="line.1349"></a>
<FONT color="green">1350</FONT>          cs.setString(2, "PROJECT");<a name="line.1350"></a>
<FONT color="green">1351</FONT>          cs.execute();<a name="line.1351"></a>
<FONT color="green">1352</FONT>          success = true;<a name="line.1352"></a>
<FONT color="green">1353</FONT>        }<a name="line.1353"></a>
<FONT color="green">1354</FONT>        catch (SQLException e) {<a name="line.1354"></a>
<FONT color="green">1355</FONT>          this.logger.info("Derby: Error in compressTables()" + StackTrace.toString(e));<a name="line.1355"></a>
<FONT color="green">1356</FONT>          success = false;<a name="line.1356"></a>
<FONT color="green">1357</FONT>        }<a name="line.1357"></a>
<FONT color="green">1358</FONT>        finally {<a name="line.1358"></a>
<FONT color="green">1359</FONT>          try {<a name="line.1359"></a>
<FONT color="green">1360</FONT>            cs.close();<a name="line.1360"></a>
<FONT color="green">1361</FONT>            conn.close();<a name="line.1361"></a>
<FONT color="green">1362</FONT>          }<a name="line.1362"></a>
<FONT color="green">1363</FONT>          catch (SQLException e) {<a name="line.1363"></a>
<FONT color="green">1364</FONT>            this.logger.warning(errorClosingMsg + StackTrace.toString(e));<a name="line.1364"></a>
<FONT color="green">1365</FONT>            success = false;<a name="line.1365"></a>
<FONT color="green">1366</FONT>          }<a name="line.1366"></a>
<FONT color="green">1367</FONT>        }<a name="line.1367"></a>
<FONT color="green">1368</FONT>        this.logger.fine("Finished compressing tables.");<a name="line.1368"></a>
<FONT color="green">1369</FONT>        return success;<a name="line.1369"></a>
<FONT color="green">1370</FONT>      }<a name="line.1370"></a>
<FONT color="green">1371</FONT>      <a name="line.1371"></a>
<FONT color="green">1372</FONT>      /** {@inheritDoc} */<a name="line.1372"></a>
<FONT color="green">1373</FONT>      @Override<a name="line.1373"></a>
<FONT color="green">1374</FONT>      public boolean indexTables() {<a name="line.1374"></a>
<FONT color="green">1375</FONT>        this.logger.fine("Starting to index tables.");<a name="line.1375"></a>
<FONT color="green">1376</FONT>        boolean success = false;<a name="line.1376"></a>
<FONT color="green">1377</FONT>        Connection conn = null;<a name="line.1377"></a>
<FONT color="green">1378</FONT>        Statement s = null;<a name="line.1378"></a>
<FONT color="green">1379</FONT>        try {<a name="line.1379"></a>
<FONT color="green">1380</FONT>          conn = DriverManager.getConnection(connectionURL);<a name="line.1380"></a>
<FONT color="green">1381</FONT>          s = conn.createStatement();<a name="line.1381"></a>
<FONT color="green">1382</FONT>          <a name="line.1382"></a>
<FONT color="green">1383</FONT>          // Note: If the db is being set up for the first time, it is not an error for the drop index<a name="line.1383"></a>
<FONT color="green">1384</FONT>          // statement to fail. Thus, we simply log the occurrence. <a name="line.1384"></a>
<FONT color="green">1385</FONT>          <a name="line.1385"></a>
<FONT color="green">1386</FONT>          try {<a name="line.1386"></a>
<FONT color="green">1387</FONT>            s.execute(dropIndexSensorDataTstampStatement);<a name="line.1387"></a>
<FONT color="green">1388</FONT>          }<a name="line.1388"></a>
<FONT color="green">1389</FONT>          catch (Exception e) {<a name="line.1389"></a>
<FONT color="green">1390</FONT>            this.logger.info("Failed to drop SensorData(Tstamp) index.");<a name="line.1390"></a>
<FONT color="green">1391</FONT>          }<a name="line.1391"></a>
<FONT color="green">1392</FONT>          s.execute(indexSensorDataTstampStatement);<a name="line.1392"></a>
<FONT color="green">1393</FONT>    <a name="line.1393"></a>
<FONT color="green">1394</FONT>          try {<a name="line.1394"></a>
<FONT color="green">1395</FONT>            s.execute(dropIndexSensorDataRuntimeStatement);<a name="line.1395"></a>
<FONT color="green">1396</FONT>          }<a name="line.1396"></a>
<FONT color="green">1397</FONT>          catch (Exception e) {<a name="line.1397"></a>
<FONT color="green">1398</FONT>            this.logger.info("Failed to drop SensorData(Runtime) index.");        <a name="line.1398"></a>
<FONT color="green">1399</FONT>          }<a name="line.1399"></a>
<FONT color="green">1400</FONT>          s.execute(indexSensorDataRuntimeStatement);<a name="line.1400"></a>
<FONT color="green">1401</FONT>          <a name="line.1401"></a>
<FONT color="green">1402</FONT>          try {<a name="line.1402"></a>
<FONT color="green">1403</FONT>            s.execute(dropIndexSensorDataToolStatement);<a name="line.1403"></a>
<FONT color="green">1404</FONT>          }<a name="line.1404"></a>
<FONT color="green">1405</FONT>          catch (Exception e) {<a name="line.1405"></a>
<FONT color="green">1406</FONT>            this.logger.info("Failed to drop SensorData(Tool) index.");                <a name="line.1406"></a>
<FONT color="green">1407</FONT>          }<a name="line.1407"></a>
<FONT color="green">1408</FONT>          s.execute(indexSensorDataToolStatement);<a name="line.1408"></a>
<FONT color="green">1409</FONT>          <a name="line.1409"></a>
<FONT color="green">1410</FONT>          try {<a name="line.1410"></a>
<FONT color="green">1411</FONT>            s.execute(dropIndexProjectNameStatement);<a name="line.1411"></a>
<FONT color="green">1412</FONT>          }<a name="line.1412"></a>
<FONT color="green">1413</FONT>          catch (Exception e) {<a name="line.1413"></a>
<FONT color="green">1414</FONT>            this.logger.info("Failed to drop Project(ProjectName) index.");                <a name="line.1414"></a>
<FONT color="green">1415</FONT>          }<a name="line.1415"></a>
<FONT color="green">1416</FONT>          s.execute(indexProjectNameStatement);<a name="line.1416"></a>
<FONT color="green">1417</FONT>    <a name="line.1417"></a>
<FONT color="green">1418</FONT>          s.close();<a name="line.1418"></a>
<FONT color="green">1419</FONT>          success = true;<a name="line.1419"></a>
<FONT color="green">1420</FONT>        }<a name="line.1420"></a>
<FONT color="green">1421</FONT>        catch (SQLException e) {<a name="line.1421"></a>
<FONT color="green">1422</FONT>          this.logger.info("Derby: Error in indexTables()" + StackTrace.toString(e));<a name="line.1422"></a>
<FONT color="green">1423</FONT>          success = false;<a name="line.1423"></a>
<FONT color="green">1424</FONT>        }<a name="line.1424"></a>
<FONT color="green">1425</FONT>        finally {<a name="line.1425"></a>
<FONT color="green">1426</FONT>          try {<a name="line.1426"></a>
<FONT color="green">1427</FONT>            s.close();<a name="line.1427"></a>
<FONT color="green">1428</FONT>            conn.close();<a name="line.1428"></a>
<FONT color="green">1429</FONT>          }<a name="line.1429"></a>
<FONT color="green">1430</FONT>          catch (SQLException e) {<a name="line.1430"></a>
<FONT color="green">1431</FONT>            this.logger.warning(errorClosingMsg + StackTrace.toString(e));<a name="line.1431"></a>
<FONT color="green">1432</FONT>            success = false;<a name="line.1432"></a>
<FONT color="green">1433</FONT>          }<a name="line.1433"></a>
<FONT color="green">1434</FONT>        }<a name="line.1434"></a>
<FONT color="green">1435</FONT>        this.logger.fine("Finished indexing tables.");<a name="line.1435"></a>
<FONT color="green">1436</FONT>        return success;<a name="line.1436"></a>
<FONT color="green">1437</FONT>      }<a name="line.1437"></a>
<FONT color="green">1438</FONT>      <a name="line.1438"></a>
<FONT color="green">1439</FONT>      /** {@inheritDoc} */<a name="line.1439"></a>
<FONT color="green">1440</FONT>      @Override<a name="line.1440"></a>
<FONT color="green">1441</FONT>      public int getRowCount(String table) {<a name="line.1441"></a>
<FONT color="green">1442</FONT>        int numRows = -1;<a name="line.1442"></a>
<FONT color="green">1443</FONT>        Connection conn = null;<a name="line.1443"></a>
<FONT color="green">1444</FONT>        PreparedStatement s = null;<a name="line.1444"></a>
<FONT color="green">1445</FONT>        ResultSet rs = null;<a name="line.1445"></a>
<FONT color="green">1446</FONT>        String statement = "Select COUNT(1) from " + table;<a name="line.1446"></a>
<FONT color="green">1447</FONT>        try {<a name="line.1447"></a>
<FONT color="green">1448</FONT>          conn = DriverManager.getConnection(connectionURL);<a name="line.1448"></a>
<FONT color="green">1449</FONT>          s = conn.prepareStatement(statement);<a name="line.1449"></a>
<FONT color="green">1450</FONT>          rs = s.executeQuery();<a name="line.1450"></a>
<FONT color="green">1451</FONT>          rs.next();<a name="line.1451"></a>
<FONT color="green">1452</FONT>          numRows = rs.getInt(1);<a name="line.1452"></a>
<FONT color="green">1453</FONT>        }<a name="line.1453"></a>
<FONT color="green">1454</FONT>        catch (SQLException e) {<a name="line.1454"></a>
<FONT color="green">1455</FONT>          this.logger.info("Derby: Error in getRowCount: " + StackTrace.toString(e));<a name="line.1455"></a>
<FONT color="green">1456</FONT>        }<a name="line.1456"></a>
<FONT color="green">1457</FONT>        finally {<a name="line.1457"></a>
<FONT color="green">1458</FONT>          try {<a name="line.1458"></a>
<FONT color="green">1459</FONT>            rs.close();<a name="line.1459"></a>
<FONT color="green">1460</FONT>            s.close();<a name="line.1460"></a>
<FONT color="green">1461</FONT>            conn.close();<a name="line.1461"></a>
<FONT color="green">1462</FONT>          }<a name="line.1462"></a>
<FONT color="green">1463</FONT>          catch (SQLException e) {<a name="line.1463"></a>
<FONT color="green">1464</FONT>            this.logger.warning(errorClosingMsg + StackTrace.toString(e));<a name="line.1464"></a>
<FONT color="green">1465</FONT>          }<a name="line.1465"></a>
<FONT color="green">1466</FONT>        }<a name="line.1466"></a>
<FONT color="green">1467</FONT>        return numRows;<a name="line.1467"></a>
<FONT color="green">1468</FONT>      }<a name="line.1468"></a>
<FONT color="green">1469</FONT>      <a name="line.1469"></a>
<FONT color="green">1470</FONT>      /** {@inheritDoc} */<a name="line.1470"></a>
<FONT color="green">1471</FONT>      @Override<a name="line.1471"></a>
<FONT color="green">1472</FONT>      public Set&lt;String&gt; getTableNames() {<a name="line.1472"></a>
<FONT color="green">1473</FONT>        Set&lt;String&gt; tableNames = new HashSet&lt;String&gt;();<a name="line.1473"></a>
<FONT color="green">1474</FONT>        tableNames.add("SensorData");<a name="line.1474"></a>
<FONT color="green">1475</FONT>        tableNames.add("SensorDataType");<a name="line.1475"></a>
<FONT color="green">1476</FONT>        tableNames.add("HackyUser");<a name="line.1476"></a>
<FONT color="green">1477</FONT>        tableNames.add("Project");<a name="line.1477"></a>
<FONT color="green">1478</FONT>        return tableNames;<a name="line.1478"></a>
<FONT color="green">1479</FONT>      }<a name="line.1479"></a>
<FONT color="green">1480</FONT>    }<a name="line.1480"></a>




























































</PRE>
</BODY>
</HTML>
